There are other methods but here is one.

=IF(A1="","",LOOKUP(A1,{"Asia Pacific","Europe","North
America"},{"APAC","EU","NA"}))


Gord

On Fri, 1 Jun 2012 20:18:13 +0000, JackofAllTrades
wrote:


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!