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