Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.