if with two vlookups doesn’t work

Hi guys,

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:

1111 OK
2222 OK
3333 OK
4444 OK
5555 OK
6666 #N/A
7777 #N/A
8888 #N/A
9999 #N/A
11110 #N/A

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.


Leave a Reply

Your email address will not be published. Required fields are marked *