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.