Can you do two Vlookup tables in one sheet?
 

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.

Can you do two Vlookup tables in one sheet?
 

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.