software

Hi, I have an equation that is getting the data from the 2nd column of a new
data workbook, after comparing a column in my workbook to the 1st column of
new data book. The problem with is cannot get ISNA to work in conjunction
with, so n/a's do not show. Have:

=VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)

gets 1st column into old doc fine, but I can not seem to use an IF in front
of, to exclude a couple of items (to mention again, can't get rid of N/A..)

=IF(OR(V124={quot;quot;,quot;.quot;,quot;.sym.quot;}),quot;quot;,

does not work, hope enough info.. thanks

Just use

=IF(ISNA(lookup_formula),quot;quot;,lookup_formula)--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;nastechquot; gt; wrote in message
...
gt; Hi, I have an equation that is getting the data from the 2nd column of a
new
gt; data workbook, after comparing a column in my workbook to the 1st column
of
gt; new data book. The problem with is cannot get ISNA to work in conjunction
gt; with, so n/a's do not show. Have:
gt;
gt; =VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)
gt;
gt; gets 1st column into old doc fine, but I can not seem to use an IF in
front
gt; of, to exclude a couple of items (to mention again, can't get rid of
N/A..)
gt;
gt; =IF(OR(V124={quot;quot;,quot;.quot;,quot;.sym.quot;}),quot;quot;,
gt;
gt; does not work, hope enough info.. thanks
You could also use

=IF(V124={quot;quot;,quot;.quot;,quot;.sym.quot;},quot;quot;,VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FAL
SE)

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;nastechquot; gt; wrote in message
...
gt; Hi, I have an equation that is getting the data from the 2nd column of a
new
gt; data workbook, after comparing a column in my workbook to the 1st column
of
gt; new data book. The problem with is cannot get ISNA to work in conjunction
gt; with, so n/a's do not show. Have:
gt;
gt; =VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)
gt;
gt; gets 1st column into old doc fine, but I can not seem to use an IF in
front
gt; of, to exclude a couple of items (to mention again, can't get rid of
N/A..)
gt;
gt; =IF(OR(V124={quot;quot;,quot;.quot;,quot;.sym.quot;}),quot;quot;,
gt;
gt; does not work, hope enough info.. thanks
thankyou!! is there a name for the fault that produces, using 2 If Not's I
guesse.. thanks

quot;Bob Phillipsquot; wrote:

gt; Just use
gt;
gt; =IF(ISNA(lookup_formula),quot;quot;,lookup_formula)
gt;
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;nastechquot; gt; wrote in message
gt; ...
gt; gt; Hi, I have an equation that is getting the data from the 2nd column of a
gt; new
gt; gt; data workbook, after comparing a column in my workbook to the 1st column
gt; of
gt; gt; new data book. The problem with is cannot get ISNA to work in conjunction
gt; gt; with, so n/a's do not show. Have:
gt; gt;
gt; gt; =VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)
gt; gt;
gt; gt; gets 1st column into old doc fine, but I can not seem to use an IF in
gt; front
gt; gt; of, to exclude a couple of items (to mention again, can't get rid of
gt; N/A..)
gt; gt;
gt; gt; =IF(OR(V124={quot;quot;,quot;.quot;,quot;.sym.quot;}),quot;quot;,
gt; gt;
gt; gt; does not work, hope enough info.. thanks
gt;
gt;
gt;

Sorry, I don't understand the question. Can you clarify?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;nastechquot; gt; wrote in message
news
gt; thankyou!! is there a name for the fault that produces, using 2 If Not's I
gt; guesse.. thanks
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Just use
gt; gt;
gt; gt; =IF(ISNA(lookup_formula),quot;quot;,lookup_formula)
gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;
gt; gt; quot;nastechquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi, I have an equation that is getting the data from the 2nd column of
a
gt; gt; new
gt; gt; gt; data workbook, after comparing a column in my workbook to the 1st
column
gt; gt; of
gt; gt; gt; new data book. The problem with is cannot get ISNA to work in
conjunction
gt; gt; gt; with, so n/a's do not show. Have:
gt; gt; gt;
gt; gt; gt; =VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)
gt; gt; gt;
gt; gt; gt; gets 1st column into old doc fine, but I can not seem to use an IF in
gt; gt; front
gt; gt; gt; of, to exclude a couple of items (to mention again, can't get rid of
gt; gt; N/A..)
gt; gt; gt;
gt; gt; gt; =IF(OR(V124={quot;quot;,quot;.quot;,quot;.sym.quot;}),quot;quot;,
gt; gt; gt;
gt; gt; gt; does not work, hope enough info.. thanks
gt; gt;
gt; gt;
gt; gt;