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

How do I cronologically sort a column with names & years. 2
Calculate totals for a range of names 10
Drop Down Menu - Populate a list of matching words. 3
copy matching value rows to other sheet 2
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Dynamically lookup value based upon column heading (date) 0
Number Value Comparison and matching 0
Find the matching value from a list 1

Top