Thread: Formula Needed for Demographic Study

County-City-Sample.xlsI am not a master in excel, that's for sure... but what i thought could have been an easy formula to implement has turned into a 2 day project. Hopefully one of you genius out there can help this poor little guy

I will attach a sample of the files I am working on. Basically what we have is to sets of data, pertaining Cities and Counties within the US. The first set of data has an updated list of all correspondent cities with their correct counties. On the other hand we have a list of all Cities with no counties. What we are trying to accomplish seems simple, but i cant figure it out. I would like a formula that looks into Field A1 (City) of the complete list and then looks into Field A1 of the incomplete list if the city matches then we would like to have cell B1 of the incomplete list to pull the correspondent county.

Please help my poor soul!

Thank you in advance

=VLOOKUP(A2,'COMPLETE LIST'!$A$2:$B$3928,2,FALSE)

... copied down. THis gives N/A if it doesn't find a match, so you can use the following, which substitutes a blanck in that coase:

=IF(ISNA(VLOOKUP(A2,'COMPLETE LIST'!$A$2:$B$3928,2,FALSE)),"",VLOOKUP(A2,'COMPLETE LIST'!$A$2:$B$3928,2,FALSE))

Originally Posted by bentleybob

=VLOOKUP(A2,'COMPLETE LIST'!$A$2:$B$3928,2,FALSE)

... copied down. THis gives N/A if it doesn't find a match, so you can use the following, which substitutes a blanck in that coase:

=IF(ISNA(VLOOKUP(A2,'COMPLETE LIST'!$A$2:$B$3928,2,FALSE)),"",VLOOKUP(A2,'COMPLETE LIST'!$A$2:$B$3928,2,FALSE))

Thanks I will try it in the AM! You guys are awesome