LinkBack URL
About LinkBacks
I can't figure out why my vlookup isn't returning the column M in the Overall Tab isn't returning the Region from the CBSA to Region Tab. Why? Is there a solution?Region Help.xlsx
I can't figure out why my vlookup isn't returning the column M in the Overall Tab isn't returning the Region from the CBSA to Region Tab. Why? Is there a solution?Region Help.xlsx
You can't look up two values (you are trying to look up both the State and the Country)
Gotcha - I need it to look up both values though. Is there a way to do that?
Looking at it it appears you trying to combine F2&G2 in the first part of your vlookup then reference it in the CBSSA to Regions sheet. Is that right?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
That's correct. I want it to have an exact match of the state then county and display the region.
How about something like this?
=VLOOKUP(F2&G2,'CBSA to Regions'!C:E,3,FALSE)
where you put in a helper column in the CBSA to regions sheet that concatinates columns A & B (put in col C) then works off that?
Hi,
Try, in M2 and copy down:
=INDEX('CBSA to Regions'!$D$2:$D$3215,MATCH('Overall Database'!F2&'Overall Database'!G2,INDEX('CBSA to Regions'!$A$2:$A$3215&'CBSA to Regions'!$B$2:$B$3215,,),0))
Regards
Both of those worked! Thanks!
Another:
in M2:
=VLOOKUP(G2,INDIRECT("'CBSA to Regions'!B" & MATCH(F2,'CBSA to Regions'!A:A,0) & ":D" & MATCH(F2,'CBSA to Regions'!A:A)),3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks