Previous Topic Next Topic

Comparing data in two columns for matches

Closed
Quick hands - Jan 26, 2010 at 11:17 AM
 rizvisa1 - Jan 29, 2010 at 03:18 PM
Hello,

I am lookin for a formula that can compare two columns of data to see if they match. For example:

A B C
1 3 NO
5 5 YES
6 1 NO

Your help is greatly appreciated. Thanks!

1 response

Answer 1 / 1
rizvisa1
Jan 29, 2010 at 03:18 PM
=IF(A2=B2, "YES", "NO")

Similar discussions

Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
Match value in 2 separate columns and return a value from a 3rd
JD_Silver -
TrowaD -

1 response
How do I extract specific data from a cell in excel?
mcat79 -
ac3mark -

5 responses