Hello,

I need some assistance with a Vlookup that will look at 3 sheets. I have a formula that currently looks at 2 sheets and gathers the data but I can't figure out how to adjust the formula to look at the 3rd sheet.

This is the formula that I have that works to bring in data from 2 sheets.

=IF(ISNA(VLOOKUP(A2,SHEET2,2,0)),VLOOKUP(A2,SHEET3,2,0),VLOOKUP(A2,SHEET2,2,0))


The following formula is what I came up so far but I get a value of FALSE when the vlookup looks at the 3rd sheet.

=IF(ISNA(VLOOKUP(A2,SHEET2,2,0)),IF(ISNA(VLOOKUP(A2,SHEET3,2,0)),IF(ISNA(VLOOKUP(A2,SHEET4,2,0)),VLOOKUP(A2,SHEET4,2,0)),VLOOKUP(A2,SHEET3,2,0)),VLOOKUP(A2,SHEET2,2,0))



Thanks