Match column B in both worksheets

Closed
P - Sep 20, 2010 at 04:13 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Sep 20, 2010 at 05:49 PM
Hello,


I have 2 excel worksheets. I want to match column B in both worksheets. If there is a match, I want it to display "Yes" in a new column C in worksheet #2. How can I do this??

Please help!


2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Sep 20, 2010 at 04:49 PM
What is your definition of a "match"
0
match = the same values.

example.

worksheet 1
invoice# (column B)
123
456
789

worksheet 2
invoice# (column B)
234
567
123

123 exist on both worksheets. i would like then to have column C in worksheet 2, reflect "yes"
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Sep 20, 2010 at 05:49 PM
Use Match Function

=IF(ISERROR(MATCH(B1,Sheet1!B:B,0)),"No","Yes")
0