Hi
what do you want to do with the '*found value'

--
Regards
Frank Kabel
Frankfurt, Germany
"ShareerIslamabadiMunda" m
schrieb im Newsbeitrag
...
hi there,

i have a problem with Excel. can anyone tell me how can I search a text of
cell in sheet2 in the cell range of sheet1.

suppose that the data in cell A5 of Sheet2 is Scott, and on Sheet1 coulmn
D
have a list of names, how can I find the Scott in this case. Also I clear
one
thing the list of names are unique there is no duplications in it. so
there
will be one and only one Scott.