# 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

#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