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!

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

Ask Your Question

Weekly Poll