Excel 2007 : have Vlookup pull from 2 sheets in the same cell

[srgtennis]

I have it pulling from from sheet but I need it to grab information from another if we put information that attains to the other sheet. The formula I have now is:

=IF(ISBLANK(C3),"",VLOOKUP(C3,'R:\[02-23-2012 Raw Apples.xlsx]Processing'!$A$3:$AD$8000,5,FALSE))

I need it to grab from the same document but a different sheet, the sheet name is Juice instead of Proccessing. Also the document title was changed to 2-28-2012 but my formula didn't, it stayed on the 2-23, that won't be a problem. It seem to still work.

[NBVC]

Difficult to understand, but maybe?

=IF(ISBLANK(C3),"",IFERROR(VLOOKUP(C3,'R:\[02-28-2012 Raw Apples.xlsx]Processing'!$A$3:$AD$8000,5,FALSE),VLOOKUP(C3,'R:\[02-28-2012 Raw Apples.xlsx]Juice'!$A$3:$AD$8000,5,FALSE))

This will look first in the Processing sheet, if not found it will go to the Juice sheet... same ranges.

[srgtennis]

It doesn't seem to work?

[srgtennis]

=IF(ISBLANK(C45),"",VLOOKUP(C45,'[02-28-2012 Raw Apples.xlsx]Processing'!$A$3:$AD$8000,5,FALSE)),VLOOKUP(C45,'[02-28-2012 Raw Apples.xlsx]Juice'!$A$3:$I$8000,4,FALSE))

I can't get this to work. Need it to pull from Processing and from Juice. The first section works by itself but when I add the second section it won't work.

[srgtennis]

they both work it I seperate them but they won't work together.

[NBVC]

Are you using Excel 2007?

if not try:

Please Login or Register  to view this content.

[srgtennis]

yes I am using excel 2007

[srgtennis]

Yes that formula works awesome thank you. what does the "isna" mean?

[NBVC]

If you are using EXCEL 2007, then the original should work, you need to just add another closing parenthesis at the end to my formula.....

the ISNA() means if the result of the first VLOOKUP is #N/A error (meaning no matches found), then go to the other VLOOKUP, else do the first VLOOKUP.