I'm trying to use VLOOKUP to search a data set of US Counties to give me the total number of full-time employees for that specific county. The issue I'm having is there are multiple counties with the same name (see attached image) so I need to look at the State as well to insure I get the correct information...
Ex:
The County of Adams Colorado has 1,676 full-time employees where as the County of Adams Mississippi has 535 full-time employees...
Thanks for the help!
Excel Problem.jpg
Bookmarks