look up

Copper Contributor

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

1 Reply


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.