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

=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)


"Funkyfido" wrote in message
...
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