Formula to return a value in column B conditional upon the value in Column A

  • Thread starter JackofAllTrades
  • Start date
J

JackofAllTrades

Hi!

I'm trying to write a formula in column B to return the value of "NA" i
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 th
answer.

Any takers? Thanks in advance
 
G

Gord Dibben

There are other methods but here is one.

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


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Sum of values in column A based on 0/1 of column B 2
Start a mail merge upon opening the document 1
Copy corresponding cell in Column B if cell in A contains certain text? 1
Lookup function to return highest value 4
Highlight every 5th recurrence in a column for a given value/id 1
Value of the first day of a year in a list 5
Repeat value in column A by number in column B in column C 14

Top