Finding and matching data based on criteria....

[Datagirl8472]

Happy new year lovely Excel People

Could I pick your brains?

I have a two sheet workbook. Each row of informaiton has a unique idenifier. I need to see if a row that appears in sheet 1 appears in sheet 2. Is this where vlookup comes in or do you think there is a batter way of doing this?

Thanks so much

[benishiryo]

welcome to the forum~ a happy new year to you too & feel free to use our brains. say sheet1 contains:
Data Range

	A
1	a
2	b
3	c
4	d

and sheet2:
Data Range

	A
1	x
2	a
3	y
4	z
5	c

here's what a VLOOKUP (Column B) & COUNTIF (Column C) will return if you do the formula in Sheet1:
Data Range

	A	B	C
1	a	a	1
2	b	#N/A	0
3	c	c	1
4	d	#N/A	0

B1:
=VLOOKUP(A1,Sheet2!A:A,1,0)
if the value appears, it will show as the same name. if not, N/A appears. i normally use VLOOKUP to retrieve another value instead. like something beside a on sheet 2

C1:
=COUNTIF(Sheet2!A:A,A1)
if it appears, it show as 1. otherwise 0

or if you want it to be clearer, do an IF or logical test. for eg.
=COUNTIF(Sheet2!A:A,A1)>0

so if it's greater than 0, it will show as TRUE & means it appeared. or:
=IF(COUNTIF(Sheet2!A:A,A1),"Appeared","no")