Really desperate for your help here. Can’t get my head around why this formula does not work. Im using excel 2002 and trying to used If with such condition:
It only retrieves the 1st vlookup (fist 5 entries), but does not retrieves the result of 2nd vlookup (if false). It gives the following results:
I’ve got two files, one output file and one input file with two sheets where the vlookups need to pick the data from.
Your help would be really appreciated.