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
the image isnt showing but its best to provide a sample workbook.
If someone has helped you then please add to their Reputation
Here's a sample of the spreadsheet...
I need to look at the "Main" sheet Column D (Name) and compare it to the "County" sheet Column E (Government Name). The value I'm looking for is on "County" sheet Column G (FT Employees).
Excel Help.xlsx
Last edited by robenre2; 11-24-2014 at 05:07 PM. Reason: More information
Try this in M2 of the Main Tab,
=SUMIFS(County!G:G,County!$D:$D,$D2,County!$B:$B,$H2)
It worked! Thanks for the help!!
You're welcome.
BTW:
You might want to check your data for consistency. Ex: Mc Lean on the Main sheet vs McLean on the County sheet....same state.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks