Vlookup to gather data from 3 sheets

**wallace23** · 10-14-2011, 12:09 AM

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

**Azam Ali** · 10-14-2011, 12:41 AM

try
=iferror((VLOOKUP(A2,SHEET2,2,0),iferror((VLOOKUP(A2,SHEET3,2,0),(VLOOKUP(A2,SHEET4,2,0)))

Iferror do not work in excel 2003 or earlier versions

If your problem is not solved, upload a sample workbook with sample data and your desired results

In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button

**wallace23** · 10-14-2011, 02:24 AM

Thanks Azam for the suggestion. However it didn't work I keep getting a message that says there is a error with the formula.

Thanks

Wallace

**itsme1981** · 10-14-2011, 02:29 AM

Its probably the wrong place but can anyone please guide to me a tutorial of formulas, I am pathetic at using them..

**Azam Ali** · 10-14-2011, 02:48 AM

Hi Wallace

If your problem is not solved, upload a sample workbook with sample data and your desired results

In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button

**wallace23** · 10-14-2011, 09:29 PM

Thanks guys. I found the problem I needed an extra comma after the final vlookup IFstatement.

=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))