# Matching values

Hello!

I need a function that will let me know if A1 matches B1. Here is my example:

A1 = 12      B1 = 0         C1 should say "don't match"
A1 = 3      B1 = 5         C1 should say "don't match"
A1 = 11      B1 = UL      C1 should say "don't match"
A1 = 5      B1 = 5         C1 should say "match"
A1 = 4      B1 = 4         C1 should say "match"

Thank you!
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
You can use the following formula...

``````=if(A1=B1,"Match","Do Not Match")
``````

Saurabh...

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Finance AnalystCommented:
If you're not too bothered about the actual text, just the following in C1 and copied down will give TRUE or FALSE.

TRUE = Match
FALSE = Do not match

=A1=B1

Thanks
Rob H
Author Commented:
This is a really cool formula!! Thank you! Unfortunately, I can't give you points because I already accepted another solution.
Commented:

Rob Solution is just the breakup of the formula which i provided to you...

so if you understand if formula it works = if(condition,answer if conidtion is true,answer if condition is false)

so basically im converting the formula which is a1=b1 to match and do not match, If you remove that it will give true or false an answer..Basically you use if formula to do the masking of a particular value that instead of that value which value you want to show...

Hope this helps...

Saurabh...
Author Commented:
Saurabh,

There is no doubt you are still the best!:) Thank you for all your help!!:)
Commented: