Excel 2007 - combination of If and vlookup formula

Posted by Neo on Super User See other posts from Super User or by Neo
Published on 2012-07-09T08:28:57Z Indexed on 2012/07/09 9:18 UTC
Read the original article Hit count: 176

Filed under:

i have a cell that refer to more than 1 worksheet and display the result (value) when it found the product from the 2 sheets.

SheetA has 2 columns which column A is the value and column B is that product name, SheetB only has product name.

Below is my formula but it failed to display result of product value, instead it always display Not Found even though the product is found from the sheets, is there anything wrong with the formula ?

=IFERROR(VLOOKUP(A35,'SheetA'!A:B,1,FALSE),IFERROR(VLOOKUP(A35,'SheetB'!D19:D115,1,FALSE),"Not Found"))

© Super User or respective owner

Related posts about excel-2007