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...
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.
