Try this:-

=IF(ISERROR(VLOOKUP(C6,Sheet1!A:B,1,FALSE)),VLOOKU P(C6,Sheet2!A:B,2,FALSE),(VLOOKUP(C6,Sheet1!A:B,1, FALSE)))

Mike

"mg_sv_r" wrote:

Is it possible to make vlookup look at other sheets for a matching value when
it does not find a value on the first sheet??

To look on two sheets I tried

=IF(ISNA(VLOOKUP(C6,SHEET1!A:B,1,FALSE)),"",(VLOOK UP(C6,SHEET2!A:B,1,FALSE)))

THis always returns #N/A even for values I know are present. Also I need the
formula to look on sheet1, if it does not find it look on sheet 2 and if it
still does not find it look on sheet3.

Any ideas?

Any help would be very much appreciated.

Regards
John