I have two excel workbooks, one including data on current employees and
one including data on terminated employees, both start with the
employee No in the first column, I would like to make a vlookup on both
files at the same time, so that for example when the employee # Im
trying to vlookup is not found in the current employees file, the
vlookup would look for it in the terminated employees files instead of
just returning #N/A.

Can it be something like this:

if((vlookup(A1,current employees.xls,24,false),vlookup(A1,current
employees.xls,24,false),vlookup(A1, terminated employees.xls,24,false))


--
TarekHamouda
------------------------------------------------------------------------
TarekHamouda's Profile: http://www.excelforum.com/member.php...o&userid=33392
View this thread: http://www.excelforum.com/showthread...hreadid=532160