Vlookup?

F

Funkyfido

I have a range of data on one sheet and am trying to import that data into
another sheet but I need to look up more than one criteria to get the data.
e.g If employee is greater than 3 (text) and employee no is 1234 then give me
cell xx2 otherwise return nothing. There may also be more than one entry for
each employee in the same category. How would I do this lookup?

Thanks
 
B

Bob Phillips

=INDEX(Sheet2!A1:A100,MATCH(1,(Sheet2!B1:B100>"3")*(Sheet2!C1:C100=1234),0))

which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter

This will only get the first match though.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Top