Hi

I have two VLookup Questions for assistance please:

1) Is it possible to use an if then logical test with vlookup to check two
seperate workbooks whether the common data is there eg if the vlookup common
data is not found on one report automatically check a second report for the
data to return

( i am trying to create a single report from 2 separate reports - actually
its 3 reports , one report will have a list of employees with their empnumber
the other two reports will both have empnumber and different data that needs
to be combined into one report)

2) Is it possible to utilize VLookup to return ALL values when it matches a
record and not just the first one - eg one empnumber on one report matches on
another report via Vlookup - i want to return the 3rd column data that
contains 4 separate records for the specific empnumber - is it possible to
get all 4 records returned or am i stuck with the first one it matches from
the 3rd column?

I have been told both question 1 and 2 cannot be done the way i would like
to do it so i thought id ask the experts and find out

Thanks