VLOOKUP Help

[Rusbus1972]

Hello, I have separate exported lists of employee IDs for employees assigned to them. I need to compare the two lists and identify if any of the names associated with the IDs are spelled differently between the two lists. The lists do not have an identical number of IDs and employee names. I'm only concerned with the Ids that appear on both lists. The goal is to identify which IDs appear on both lists that have the associated names that are spelled differently between the two.

Im assuming VLOOKUP is what would be used to identify the different spelling but im not able to get the syntax of the VLOOKUP down correctly. So in the example above the formula should return that result that highlights that Row 4 has names in Colum B and E that does not match.

Any help would be apprecaited.

 

[etaf]

=countifs() maybe

how about
=IF(COUNTIF($A$2:$A$100,E2)=0,"",COUNTIF($A$2:$A$100,E2)=COUNTIFS($A$2:$A$100,E2,$B$2:$B$100,F2))

Book5
	A	B	C	D	E	F	G
1
2	1234	blow,joe		1234	blow,joe		TRUE
3	1235	flinstone, fred		1237
4	1236	smith, billy		1235	flinstone, fred		TRUE
5				1230
6				1236	smith, william		FALSE
Sheet1

Cell Formulas
Range	Formula
G2:G6	G2	=IF(COUNTIF($A$2:$A$100,D2)=0,"",COUNTIF($A$2:$A$100,D2)=COUNTIFS($A$2:$A$100,D2,$B$2:$B$100,E2))

Could add a IF , so you dont just get a FALSE _ BUT maybe an error - or even lookup the names for comparison

 

[Rusbus1972]

This works out great, Appreciate you so much. Thanks.

 

[etaf]

glad to have resolved for you