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?????????

I don't know if this will help but you can replace the value 1 by a cell
address and then change the value of the cell.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=541307