VLOOKUP Help: if value is found, or if value is not found

[darrenmccoy]

Hi Experts, Could you please help me complete this formula?
I am looking up a value in one sheet, and if it is found then display it, if it is not found, then lookup in the second sheet, if it is found display it, and then so on and so forth.

The example I have so far is:

=IF(ISNA(VLOOKUP(A2,PFLISTINGS!A:H,3,0)),"",VLOOKUP(G3,PFHIGHEND!B:E,4,0))

This is close, but not quite working. Is there a better way to achieve this?

 

[Peter_SSs]

Does this do what you want?

=IFERROR(VLOOKUP(A2,PFLISTINGS!A:C,3,0),IFERROR(VLOOKUP(G3,PFHIGHEND!B:E,4,0),""))

 

[darrenmccoy]

Thank you - Yes it does.

 

[Peter_SSs]

Thank you - Yes it does.

Cheers. Thanks for letting us know.