Search number in different column

[Firasath]

Hi,

I have a two list of mobile numbers and I need to tally those two columns of mobile number and find out if the number in the first column is present in the second column. Please advise the way to find out the same.

Regards,

Firasath

 

[texasalynn]

you could do a vlookup or a countif

 

[snoopyhr]

try this if it helps...

Excel Workbook
	E	F	G
8	*	Mobile 1	Mobile 2
9	Not on the 2nd list	Mobile # 1	Mobile # 4
10	Not on the 2nd list	Mobile # 2	Mobile # 5
11	Not on the 2nd list	Mobile # 3	Mobile # 6
12	On the 2nd list	Mobile # 4	Mobile # 7
13	On the 2nd list	Mobile # 5	Mobile # 8
14	On the 2nd list	Mobile # 6	Mobile # 11
15	On the 2nd list	Mobile # 7	Mobile # 12
16	On the 2nd list	Mobile # 8	Mobile # 13
17	Not on the 2nd list	Mobile # 9	Mobile # 14
18	Not on the 2nd list	Mobile # 10	Mobile # 15
19	On the 2nd list	Mobile # 11	*
20	On the 2nd list	Mobile # 12	*
21	On the 2nd list	Mobile # 13	*
22	On the 2nd list	Mobile # 14	*
23	On the 2nd list	Mobile # 15	*
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F9	1. / Formula is =NOT(ISNUMBER(MATCH(F9,$G$9:$G$18,0)))	Abc