Identify values in a cell based from another sheet and concatenate the results in one cell
In the attached excel file, first row is the sample output. 3rd column has all the states separated by comma and each state has a corresponding region. I need to be able to identify regions of each state and put it in the regions column. if more than 1 state is in the same region, 'Northwest' for example, just put 'Northwest'.
I hope I make sense.
Thanks guys!
Last edited by danallamas; 06-15-2015 at 12:35 AM.
I've written a UDF for you to use for this and installed it into your sample workbook.
It's used in a cell like so:
=ListRegions(Reference, ListOfStateAbbreviations, ListOfRegions, OptionalDelimiter)
=ListRegions(B2, 'Region Database'!B:B, 'Region Database'!F:F, ", ")
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This is so perfect thank you so much!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks