How to organize a list of stores to display on another worksheet as a grouped area

Occasional Visitor

I am using a spreadsheet to import raw data into a DATA tab.  I use the IF function to pull customer information (address, phone, etc.) from the DATA tab to workable table with blank columns I can add notes to.

 

Previously, I would just use a nested IF statement to pull the store locations into two areas:  COL and CLT.  Four stores in COL, and if the value was anything else, it would display CLT.  I have since acquired multiple stores in multiple regions and this would make the nested IF statement incredibly complex.  Is there another way to do this more simply?

0 Replies