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?