Lookup and Match

[AnilR]

Hi
I'm looking for a way to Lookup and Match a list of Mutual Fund names (..given to me after I download recent data from the Mutual Fund Company) with their respective Ticker Symbol. So, for example, the Mutual Fund Company gives me (via a downloaded CSV file) the following Mutual Fund names:

FID CONTRAFUND
FID GROWTH COMPANY
FID INVST GR BD
FID OTC PORTFOLIO
FID OVERSEAS
FID REAL ESTATE INVS
FID MID CAP STOCK
FID GOVT MMKT
FID SMALL CAP VALUE
FID 500 INDEX
FID EMRG MKTS IDX
FID INTL INDEX
BAIRD CORE PLUS INST
BAIRD CORE PLUS INST
COL DIVIDEND INC ADV
AF AMERICAN MUTAL R5

I would then like to Match those names (above) with their below respective Ticker Symbol (which I know) as follows:

FCNTX
FDGRX
FBNDX
FOCPX
FOSFX
FRESX
FMCSX
SPAXX
FCPVX
FXAIX
FPADX
FSPSX
BCOIX
BCOIX
CVIRX
RMFFX

Is there a way to do so? Please let me know.

Thanks. Much obliged with your answer.

 

[pecoflyer]

Please post a sample sheet
What is the link between both ranges?

 

[p45cal]

Put the two columns next to each other so that they register correctly then use the formula as above and copy down.

If you're certain that the Fund Names and the ticker symbols are in the same order, you don't need to have them next to each other, you can use INDEX/MATCH: