Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the nested functions below
"=if(vlookup(1, GRID, 3,false) = 0, (1, GRID, 4, false), (1, GRID, 3, false))" i.e for the row with the digit one in its first column return the value in the third column else if empty return the value in the fourth column. my problem is i am repeatedly using the line above exactly only changing the value i am searching for (1 in this case )) so ideally i'd like to do something like define myformula(X) = if(vlookup(X, GRID, 3,false) = 0, (X, GRID, 4, false), (X, GRID, 3, false)) is this possible????????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a formula by joining text and the value from a formula | Excel Worksheet Functions | |||
I am trying to create a formula | Excel Worksheet Functions | |||
How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
Create a formula | Excel Discussion (Misc queries) | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) |