look up

[rworrich]

Worrich, Ron (7)   3 4 4 3 5 

Claus, Santa (9)

I want to look up the information for Worrich, Ron and put into another cell. How do I get the information and ignore what is in the paratheses

[#2]

@rworrich 

There are several ways of retrieving information using a partial match (in this case, the person's name without the number in parentheses).  See the attached workbook for examples and notes.