Trying to pull unique values from another sheet's column
Just as the title says, I'm trying to build a solution that parses and lists the "Region Name" field in a sheet, so it can build another list based on "Regional Partner". Basically, I'm trying to build an abstract method of building a list of regions and their associated regional partners. Why? Because these 2 fields seems to change more frequently than I'd like to admit.
Anyway, through some searching, I found Paul's solution; https://app.smartsheet.com/b/publish?EQBCT=416b5082452c49029af303c13250f7da
Problem is, the data isn't in comma delimited cells. It's 20+ rows of the same name.
I'm trying to pull from "Office Directory - 20210223" into "New Chair Installs (Metrics)". I should probably break this off into it's own sheet.
The above shows what I'm trying to achieve, and the below is what I've tried.
I'm at my wits end.
EDIT: I know I'm not the best of explainers. If I can just pull the "Region Name" dynamically, I can use INDEX/MATCH formulas to pull the rest of the info I need.
Help Article Resources
Check out the Formula Handbook template!