I'm currently using the following formula.
I need to add to this formula the following:=IF($A13="LM Coordinated Audiences","STG Led",IF($A13="Workload Optimized Infrastructure","STG Led",IF($A13="Workload Optimized Systems","STG Led",IF($A13="STG - Competitive & Install","STG Led",IF($A13="LM Targeted Need-States","STG Led"," ")))))
If column A = Industry Leadership & column B = one of the following countries, then call it "STG Led"
Countries:
GMU-ASEAN
GMU-CEE
GMU-GCG
GMU-India-South Asia
GMU-Korea
GMU-LA-Brazil
GMU-LA-Mexico
GMU-LA-SSA
GMU-MEA
NEE-Alps
NEE-Nordic
SWE-France
SWE-Italy
1st, I don't know how to do the formula, and 2nd I think the formula would be too long. So, I'm struggling with what would be my best option. I've attached a spreadsheet. Thanks for any help you can provide.
Bookmarks