Need Help

bradleysmith87

New Member
Joined
Oct 27, 2006
Messages
0
I got 2 excel files...

One that includes random Cities, and one that includes MSA codes. I need to get MSA codes to the corresponding cities on the other file.
I don't want to input 10000 entries by hand, having to search through all the data. Is there something I can do that will match the city and input the respected code in the column next to it?

Thanks and please help if you can

brad
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,113,788
Messages
5,544,278
Members
410,601
Latest member
Silver2
Top