| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning 1 of 4 values if conditions are met
Both of these worked! Thanks so much!!!
On Thursday, February 13, 2014 1:38:50 PM UTC-4, Claus Busch wrote: Hi Tricia, Am Thu, 13 Feb 2014 18:33:57 +0100 schrieb Claus Busch: try: =(B2&C2="1M<12M")+(B2&C2="<1M<12M")*2+(B2&C2="1M 12M")*3+(B2&C2="<1M12M")*4 or =VLOOKUP(B2&C2,{"1M<12M",1;"<1M<12M",2;"1M12M", 3;"<1M12M",4},2,0) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning values listed under multiple conditions | Excel Worksheet Functions | |||
| Returning a value if multiple conditions are met | Excel Worksheet Functions | |||
| Returning a value if multiple conditions are met | Excel Worksheet Functions | |||
| Returning a Value if 3 Conditions are True | Excel Worksheet Functions | |||
| returning values from columns to another sheet, based on conditions | Excel Programming | |||
Threaded Mode
