Search a table to match 3 criteria

[Joe Blow]

From SARDOG

Hi folks. I import a table from Access containing some budget
information. That table contains 6 columns and a varying number of
rows. I need to create a formula that will search the table and return
a value based on three criteria or matches. EG criteria A, B, C, and
return a value from a designated Column. Vlookup only allows me 1
critera. I have tried using nested If statements but the imported data
does not always appear on the same row. Is there a way to nest the
lookup function or is there another function I could use. Thanks
SARDOG

 

[Alan Beban]

A brief illustration, say 6 columns and 6 rows, illustrating your data
and the result you're seeking might help us to help you.

Alan Beban