• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLOOKUP question2

Jaimee001

Jaimee001

Member
I had a blast today doing VLOOKUPs at work. But now I've run into a snag. I tried to do sort of a backwards VLOOKUP (if there is such a thing). I have compare a file where the C column DOESN'T match the A column. When I run my VLOOKUP I get the name where there is a match and a #NA where there isn't. I'd like to get the name where it doesn't match.

I tried to do a IFERROR/VLOOKUP and was able to name the field in questions "no match" but that's not what I need. Thank you for your time and help, I always appreciate the information here at Chandoo. Here is my file:

[pre]http://speedy.sh/cJRaJ/EXAMPLE-OF-VLOOKUP2-TEST-FILE.xlsx[/pre]

I hope I'm making sense.....
 
Hi ,


Try this in E3 :


=IF(ISERROR(MATCH(C3,$A$3:$A$15,0)),C3,"")


Is this what you are looking for ? If so , you can use this same method for your result 3.


Narayan
 
This has been nothing short of fabulous. I'm so indebted to this site. I've learned so much and there's so much more to learn...THANK YOU!!!!! This works perfectly!

I can do this in access but I'm really pushing myself to learn excel to get my certification.....
 
You must log in or register to reply here.
Back
Top