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

JackofAllTrades JackofAllTrades is offline

Junior Member

Posts: 3

Thank you! I'm going to try the nested if statements!

Quote:

Originally Posted by Spencer101

Two ways of doing this...

1) Nested IF statements

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

2) Lookup table

Put a table somewhere in the workbook that has North America, Europe, South Pacific in one column and NA, EU, APAC in the corresponding cells of the next column. Then use VLOOKUP to return the relevant value.

Hope that helps.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 07:57 AM.

Menu

About Us