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