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.

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))