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:

=IF(VLOOKUP(A1;[Input.xls]Sheet1!$A$1:$B$5;2;0)=”OK”;”OK”;VLOOKUP(A1;[Input.xls]Sheet2!$A$1:$B$5;2;0))

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.

/Andy.

19 thoughts on “if with two vlookups doesn’t work

  1. Anabolika kaufen

    I’ll right away grasp your rss as I can not to find your email subscription hyperlink or newsletter service. Do you’ve any? Please let me recognise in order that I may subscribe. Thanks.

  2. anabole steroide bestellen

    When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get four e-mails with the same comment. Is there any way you can remove people from that service? Thanks a lot!

  3. Acheter Phentermine

    Nice blog here! Also your website loads up fast! What web host are you using? Can I get your affiliate link to your host? I wish my website loaded up as quickly as yours lol

  4. anabolika kaufen

    Hi there just wanted to give you a quick heads up. The text in your article seem to be running off the screen in Opera. I’m not sure if this is a formatting issue or something to do with web browser compatibility but I thought I’d post to let you know. The design look great though! Hope you get the issue resolved soon. Many thanks

  5. ig

    I do agree with all of the ideas you’ve offered for your post.

    They are really convincing and can certainly work.
    Nonetheless, the posts are very brief for beginners.
    May just you please prolong them a little from next time?

    Thanks for the post.

  6. click here for more info

    I’ve been surfing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. Personally, if all webmasters and bloggers made good content as you did, the internet will be a lot more useful than ever before.

  7. Buy Pain Relief

    Definitely believe that which you said. Your favorite justification seemed to be on the net the easiest thing to be aware of. I say to you, I certainly get irked while people consider worries that they plainly do not know about. You managed to hit the nail upon the top and defined out the whole thing without having side effect , people can take a signal. Will likely be back to get more. Thanks

  8. Buy Handicraft Products

    Hello! I could have sworn I’ve been to this site before but after browsing through some of the post I realized it’s new to me. Anyhow, I’m definitely glad I found it and I’ll be bookmarking and checking back frequently!

Comments are closed.