Hi all,
I am having issues returning a "match" or "not match" in excel 2016 when comparing columns from two different sheets.
Sheet 1 Sheet 2
NAME # NAME #
JON 25 JON 25
KARA 26 KARA 26
EDDY 27 Eddy 27
Sarah 28 Sarah 28
Emily 55 Emily 30
I am using this formula in Sheet 1:
=IF(B2=Sheet2!B2,"MATCH","NO MATCH")
Unfortunately, when i apply this to emily is still comes back as a "match" instead of a "no match"
Any help?
What is in B2? Is it the name or the number? If the name, then maybe this:
=IF(B2&C2=Sheet2!B2&Sheet2!C2,"MATCH","NO MATCH")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Ali!
Thanks for the response. In b2, it is the number, so 25 for JON. B1 is the name
OK. Can you attach the file? Sounds very odd.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks