Try something like this.........if you still have trouble, post what you are
trying and what results you're getting.......

=IF(ISNA(VLOOKUP(A1,SHEET1!A:B,2,FALSE)),VLOOKUP(A 1,SHEET2!A:B,2,FALSE),VLOOKUP(A1,SHEET1!A:B,2,FALS E))

Vaya con Dios,
Chuck, CABGx3


"Bob C" wrote:

I am having an issue in a file where I have three sheets and I am attempting
to combine VLOOKUP results into the third sheet.

The second VLOOKUP does not appear to be working correctly.