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