Forum Discussion
Autofill a name based on data from another column
Hello,
I have been trying to figure out how to accomplish this and haven't had any luck- so any ideas would be appreciated!
My company covers a large geographic area- about 100 counties. I have data where each row has information and then the geographic information on where that information comes from (columns for city, state, county, and zip code). The individuals in my company (about a dozen different people) are assigned who is responsible for it by county/zip code. I want to have a new column that auto-fills the person's name who is responsible for it by the county or zipcode that is in that row of data.
Any point in the right direction would be super helpful! Thanks so much!
3 Replies
The easiest way would be to create a list of all your country/zip codes and assign a person to each. Then you can use VLOOKUP to match a person with every entry in your list with all geographical locations. You'll find a simplified example in the attached workbook.
Riny_van_Eekelen I just tried it out with my own data and it worked beautifully! Thank you so so much- I really appreciate it!
- You’re welcome.
