Vlookup over 2 column first shows N/A

[chally3]

Hi everyone,

Can someone please help, I have enevr had to do this before.

I have a standard lookup formula =VLOOKUP(E:E,[mc.9.xlsx]mc.9!$A:$G,4,0) but if the first result comes back as #N/A then look again but in column 6


Is this possible?

Thank you

 

[Fluff]

How about
=IFERROR(VLOOKUP(E:E,[mc.9.xlsx]mc.9!$A:$G,4,0),VLOOKUP(E:E,[mc.9.xlsx]mc.9!$A:$G,6,0))

 

[chally3]

absolutely perfect, thank you very much.

 

[Fluff]

You're welcome & thanks for the feedback