LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 3
Default Formula to return a value in column B conditional upon the value in Column A

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting formula to highlight items on column B inrelation to column A hombreazul Excel Discussion (Misc queries) 4 March 4th 12 02:43 PM
Field or formula to return last value in a column? Eric Excel Discussion (Misc queries) 7 April 13th 09 04:43 PM
Formula to return column letters DoubleZ Excel Discussion (Misc queries) 4 July 22nd 08 09:23 PM
Return text in Column A if Column B and Column K match jeannie v Excel Worksheet Functions 4 December 13th 07 07:36 PM
column to column conditional formatting won't work, need formula rrupp Excel Worksheet Functions 1 August 23rd 05 10:06 PM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"