software

I am using the nested functions below

quot;=if(vlookup(1, GRID, 3,false) = 0, (1, GRID, 4, false), (1, GRID, 3, false))quot;

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

Why not use the following one:

=IF(A1=1,C1,D1)

to get what you want:
[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].

Not quite sure what you want.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================

quot;jamesquot; gt; wrote in message
...
gt;I am using the nested functions below
gt;
gt; quot;=if(vlookup(1, GRID, 3,false) = 0, (1, GRID, 4, false), (1, GRID, 3,
gt; false))quot;
gt;
gt; i.e for the row with the digit one in its first column return the value in
gt; the third column else if empty return the value in the fourth column.
gt;
gt; my problem is i am repeatedly using the line above exactly only changing
gt; the
gt; value i am searching for (1 in this case ))
gt;
gt; so ideally i'd like to do something like
gt;
gt; define myformula(X) = if(vlookup(X, GRID, 3,false) = 0, (X, GRID, 4,
gt; false),
gt; (X, GRID, 3, false))
gt;
gt; is this possible?????????
james, like Daniel CHEN, I'm not quite sure what you're looking for, but keep
in mind that where you are using 1 you could use a reference to a cell that
contains the value 1. So if you put 1 in cell F1, for example, you could
rewrite the formula above as =IF(A1=$F$1,C1,D1)

quot;Daniel CHENquot; wrote:

gt; Why not use the following one:
gt;
gt; =IF(A1=1,C1,D1)
gt;
gt; to get what you want:
gt; [for the row with the digit one in its first column return the value in the
gt; third column else if empty return the value in the fourth column].
gt;
gt; Not quite sure what you want.
gt;
gt; --
gt; Best regards,
gt; ---
gt; Yongjun CHEN
gt; =================================
gt; XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
gt; - - - - www.XLDataSoft.com - - - -
gt; Free Excel-Based Data Processing Tool is Available for Download
gt; Free Excel / VBA Training Materials is Available for Download
gt; =================================
gt;
gt; quot;jamesquot; gt; wrote in message
gt; ...
gt; gt;I am using the nested functions below
gt; gt;
gt; gt; quot;=if(vlookup(1, GRID, 3,false) = 0, (1, GRID, 4, false), (1, GRID, 3,
gt; gt; false))quot;
gt; gt;
gt; gt; i.e for the row with the digit one in its first column return the value in
gt; gt; the third column else if empty return the value in the fourth column.
gt; gt;
gt; gt; my problem is i am repeatedly using the line above exactly only changing
gt; gt; the
gt; gt; value i am searching for (1 in this case ))
gt; gt;
gt; gt; so ideally i'd like to do something like
gt; gt;
gt; gt; define myformula(X) = if(vlookup(X, GRID, 3,false) = 0, (X, GRID, 4,
gt; gt; false),
gt; gt; (X, GRID, 3, false))
gt; gt;
gt; gt; is this possible?????????
gt;
gt;
gt;