Can you do two Vlookup tables in one sheet?

B

Bob C

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.
 
C

CLR

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(A1,SHEET2!A:B,2,FALSE),VLOOKUP(A1,SHEET1!A:B,2,FALSE))

Vaya con Dios,
Chuck, CABGx3
 
Top