Hello,

I'm trying to develop a sales spreadsheet that helps me to analyze potential business partners based on certain criteria.

Where I'm getting held up is that some of the criteria have multiple options and I would like to be able to select more than one option and have a value associate with each option.

For instance:

One of the criteria for ranking is Geography.
If a partner has locations in multiple geographies (ex. APAC, EU, NA, etc.) I want to be able to select all of their current geographies.
However, some geographies are valued more than others. I would value NA = 3 whereas APAC = 1.

How do I assign these values to each geography individually but be able to select multiple geographies in one cell that ultimately lead to a final value that I can appropriately judge a potential partner?


I hope this makes sense.

I appreciate your responses in advanced.