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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,118,767
Messages
5,574,130
Members
412,573
Latest member
Chriszion
Top