=VLOOKUP("*"&"(3)"&"*",A2:B50,2,0)

but that will only find one value, better would be to use autofilter and
custom then from dropdown select contains and put (3) in the criteria, then
select the filtered table and copy somewhere else


--
Regards,

Peo Sjoblom





"niatpac" wrote in message
...
I am trying to find for example "(3)" in a column of 50 rows where each row
has a name in it. The name for example may be "Jones" in row 1 and "Smith
(3)" in row 8. The "(3)" means something to me in the database. I need
to
seperate each name that is marked by the "(3)" and utilize the information
in
the next column that corresponds with the "(3)". How do I use VLOOKUP to
find part of this string?