I've run into a bit of a situation here:
Table 1 consists of two columns: client name and zip code.
Table 2 is essentially a master list of all the post offices across the US, also with two columns: zip code and city name.
How can I add a third column to Table 1 that automatically pulls in the city name from Table 2? I'm positive there's a way to handle this in Excel, I just haven't been able to track down the right method!
The list has about 4,000 clients, so getting this automated would be a massive time-saver for me.
Does anyone happen to know the best way to tackle this?
Table 1 consists of two columns: client name and zip code.
Table 2 is essentially a master list of all the post offices across the US, also with two columns: zip code and city name.
How can I add a third column to Table 1 that automatically pulls in the city name from Table 2? I'm positive there's a way to handle this in Excel, I just haven't been able to track down the right method!
The list has about 4,000 clients, so getting this automated would be a massive time-saver for me.
Does anyone happen to know the best way to tackle this?