Searching cells for a cell match

Microsoft Excel 2003 (full product)
September 4, 2009 at 14:21:17
Specs: Windows XP PRO SP2, P4 - 2.66GHz / 2 Gigs DDR
Hello, I am wondering if anyone has a script that will look for the contents of one cell in a list of other cells. For example: In cell C2 I have a 10 digit phone number. In column E, I have a list of phone numbers ranging from E2:E100. What I would like to do is take the number in C2 and look for it in the E2:E100 range and then if it is found, I would like it to be entered into D2 and then loop through all cells in column C that have a number repeating the search until the cell in C is empty.


See More: Searching cells for a cell match

Report •


#1
September 4, 2009 at 18:24:08
Do you mean you have something like this?

	C	D	E
1
2	11		11
3	35		33
4	23		45
5	54		35
6	21		55
7			65
8			21
9			23

And you want something like this?

	C	D	E
1
2	11	11	11
3	35	35	33
4	23	23	45
5	54		35
6	21	21	55
7			54
8			21
9			23

If so, in D2 put this formula and drag it down...

=IF(ISNA(VLOOKUP(C2,$E$2:$E$100,1,0)),"",VLOOKUP(C2,$E$2:$E$100,1,0))


Report •
Related Solutions


Ask Question