Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a cell that refers to more than one worksheet and displays the result (value) when it finds the product from the two sheets. SheetA has two columns, of which column A is the value and column B is that product name. SheetB only has product name.

Below is my formula but it fails to display result of product value, instead it always displays 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"))

share|improve this question
Hi @Neo, please have a look at this question and see if it answers your question. If it doesn't please elaborate on what didn't work – Ivo Flipse Jul 9 '12 at 11:40
That case involve only 2 sheets. For my case, i am working on 3 sheets. Lookup value on SheetC which refer to columns from SheetA and SheetB. – Neo Jul 12 '12 at 8:09

The content of A35 will not be found by the first VLOOKUP (see @Ivo Flipse). So it will be searched for in SheetB, where if present in range D19:D115, it will be found. It has not been, hence "Not found". Formula is fine, whether or not in SheetC, your description maybe not.

Comment by pnuts

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .