Picking matching value from a list

R

Rich Pasco

Suppose I have a pair of columns giving nicknames and full names, e.g.

John John Q. Public
Bob Robert F. Kennedy
Marty Martin Luther King
Abe Abraham Lincoln
Dick Richard M. Nixon

Is there a worksheet function which will accept the value of a nickname
from one cell along with the location of the above table, and return
the name from the second column corresponding to the matching nickname
in the first column?

E.g. I type "Abe" and the function returns "Abraham Lincoln"?

Seems like there should be, but I can't find it.

- Rich
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate totals for a range of names 10
Drop Down Menu - Populate a list of matching words. 3
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Find the matching value from a list 1
Matching a Value with a list 1
compare and return a value from another worksheet 3
Display top 5 items from a list with matching criteria? 8

Top