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?