Multiple (nested) VLOOKUP functions

February 23, 2010 at 09:24:26
Specs: Windows XP

I have a large excel spreadsheet containing part lists in 1 column and their costs in the next column on 3 different worksheets. I am trying to create a vlookup function that will look at the part # and find it on one of the 3 worksheets and return the cost value to me. (each part # is only on 1 worksheet)
Is there a way I can use nested IF statements and VLOOKUP formulas to return the cost? I can get it to work for 2 worksheets but throwing the third in there is baffling me.
Thanks!

See More: Multiple (nested) VLOOKUP functions

Report •


#1
February 23, 2010 at 10:09:12

Hi,

This formula looks for a value from column A in sheet1
- searching in column A of sheets 2, 3 & 4,

and returning values from column B in sheets 2, 3 or 4, as appropriate.

The formula has been split onto several lines for ease of viewing.

=IF(ISNA(VLOOKUP(A1,Sheet2!$A$1:$B$25,1,FALSE)),
IF(ISNA(VLOOKUP(A1,Sheet3!$A$1:$B$25,1,FALSE)),
IF(ISNA(VLOOKUP(A1,Sheet4!$A$1:$B$25,1,FALSE)),"Not found",
VLOOKUP(A1,Sheet4!$A$1:$B$25,2,FALSE)),
VLOOKUP(A1,Sheet3!$A$1:$B$25,2,FALSE)),
VLOOKUP(A1,Sheet2!$A$1:$B$25,2,FALSE))

Regards


Report •
Related Solutions


Ask Question