Search a table to match 3 criteria

  • Thread starter Thread starter Joe Blow
  • Start date Start date
J

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
 
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
 
Back
Top