| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"LOOKUP" within a condition?
I have a LOOKUP that works great (Thanks Biff!!!). Now I need to two
seperate "LOOKUP" commands depeneding on contents of a different field. My exising LOOKUP, which works: =LOOKUP(TODAY()-INT(AK2), {1,30,60,90,120},{"0-29","30-59", "60-89", "90-119","Over 120}) (AK2 is the date the row was created in a database, the earliest date is 15 Sep 06). I now need to look at the value in "V2" to look for "Incident", if so, my scale will be different. By when I try my "guess", it doesn't work (figure that!?). The problem is, while scrolling through the formula, I can't ever get to the "value if true". Here's my feable attempt: =IF(V2="Incident", LOOKUP(TODAY()-INT(AK2),{1,4,14,"Over 30"},{"0-7","8-13","15-29","Over 30"},LOOKUP(TODAY()-INT(AK2), {1,30,60,90,120},{"0-29","30-59", "60-89", "90-119","Over 120}))) Appreciate any assistance, KSL. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"LOOKUP" within a condition?
Try:
=IF(V2="Incident", LOOKUP(TODAY()-INT(AK2),{1,4,14,"Over 30"},{"0-7","8-13","15-29","Over 30"}),LOOKUP(TODAY()-INT(AK2), {1,30,60,90,120},{"0-29","30-59","60-89","90-119","Over 120"})) Greg "Leonhardtk" wrote: I have a LOOKUP that works great (Thanks Biff!!!). Now I need to two seperate "LOOKUP" commands depeneding on contents of a different field. My exising LOOKUP, which works: =LOOKUP(TODAY()-INT(AK2), {1,30,60,90,120},{"0-29","30-59", "60-89", "90-119","Over 120}) (AK2 is the date the row was created in a database, the earliest date is 15 Sep 06). I now need to look at the value in "V2" to look for "Incident", if so, my scale will be different. By when I try my "guess", it doesn't work (figure that!?). The problem is, while scrolling through the formula, I can't ever get to the "value if true". Here's my feable attempt: =IF(V2="Incident", LOOKUP(TODAY()-INT(AK2),{1,4,14,"Over 30"},{"0-7","8-13","15-29","Over 30"},LOOKUP(TODAY()-INT(AK2), {1,30,60,90,120},{"0-29","30-59", "60-89", "90-119","Over 120}))) Appreciate any assistance, KSL. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"LOOKUP" within a condition?
Perfect! Looking at it now, its so obvious!
Thanks, KSL "Greg Wilson" wrote: Try: =IF(V2="Incident", LOOKUP(TODAY()-INT(AK2),{1,4,14,"Over 30"},{"0-7","8-13","15-29","Over 30"}),LOOKUP(TODAY()-INT(AK2), {1,30,60,90,120},{"0-29","30-59","60-89","90-119","Over 120"})) Greg "Leonhardtk" wrote: I have a LOOKUP that works great (Thanks Biff!!!). Now I need to two seperate "LOOKUP" commands depeneding on contents of a different field. My exising LOOKUP, which works: =LOOKUP(TODAY()-INT(AK2), {1,30,60,90,120},{"0-29","30-59", "60-89", "90-119","Over 120}) (AK2 is the date the row was created in a database, the earliest date is 15 Sep 06). I now need to look at the value in "V2" to look for "Incident", if so, my scale will be different. By when I try my "guess", it doesn't work (figure that!?). The problem is, while scrolling through the formula, I can't ever get to the "value if true". Here's my feable attempt: =IF(V2="Incident", LOOKUP(TODAY()-INT(AK2),{1,4,14,"Over 30"},{"0-7","8-13","15-29","Over 30"},LOOKUP(TODAY()-INT(AK2), {1,30,60,90,120},{"0-29","30-59", "60-89", "90-119","Over 120}))) Appreciate any assistance, KSL. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| "countif" and "and" condition | Excel Worksheet Functions | |||
| Lookup using 2 cells as the "X" and "Y" coordinates.... | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
