Hi!

I'm trying to write a formula in column B to return the value of "NA" if column A say "North America", "EU" if column A says "Europe" and "APAC" if column A says "Asia Pacific".

I'm sure there's something online but I'm not sure how to look for the answer.

Any takers? Thanks in advance!