Matching values

[Daniel Dridan]

I have a list of values in Column A and a larger list of values in Column B.
I want to know which of the values in Column A exist in Column B?

Any easy way to do this?

 

[repairman615]

Hello,

Try this in an empty column. Replace the range B1:B6 with your column B range (be sure to use the $) and A1 with the top cell of your list in Col. A.<TABLE style="WIDTH: 194pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=258><COLGROUP><COL style="WIDTH: 194pt; mso-width-source: userset; mso-width-alt: 4128" width=258><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d7e4bc; WIDTH: 194pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=21 width=258>=IF(COUNTIF($B$1:$B$6,A1),A1&" Exists","")

fill down.

Excel Workbook
	A	B	C
1	1	1	1 Exists
2	2	2	2 Exists
3	3	3	3 Exists
4	6	4	6 Exists
5		5
6		6
Sheet1

Excel 2007

Cell Formulas
Range	Formula
C1	=IF(COUNTIF($B$1:$B$6,A1),A1&" Exists","")
C2	=IF(COUNTIF($B$1:$B$6,A2),A2&" Exists","")
C3	=IF(COUNTIF($B$1:$B$6,A3),A3&" Exists","")
C4	=IF(COUNTIF($B$1:$B$6,A4),A4&" Exists","")
C5	=IF(COUNTIF($B$1:$B$6,A5),A5&" Exists","")
C6	=IF(COUNTIF($B$1:$B$6,A6),A6&" Exists","")

 

[Aladin Akyurek]

I have a list of values in Column A and a larger list of values in Column B.
I want to know which of the values in Column A exist in Column B?

Any easy way to do this?

C2, copy down:

=ISNUMBER(MATCH(A2,B:B,0))+0

with as results: Exists = 1, Don't Exist = 0