software

I would like to reference an IF formula to a specific cell. Similar to how a
VLOOKUP references a certain cell. Is this possible? I tried this;

=VLOOKUP(I3,DATA!1:65536,17)*IF(DATA!Q293=quot;CUSTOME R ERRORquot;,quot;Xquot;,)
it returns a #VALUE!

Any ideas?


scott Wrote:
gt; I would like to reference an IF formula to a specific cell. Similar to
gt; how a
gt; VLOOKUP references a certain cell. Is this possible? I tried this;
gt;
gt; =VLOOKUP(I3,DATA!1:65536,17)*IF(DATA!Q293=quot;CUSTOME R ERRORquot;,quot;Xquot;,)
gt; it returns a #VALUE!
gt;
gt; Any ideas?Suppose VLOOKUP() returns a number, you are trying to multiply a number
with a text string, which is not allowed.--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: www.excelforum.com/member.php...foamp;userid=7094
View this thread: www.excelforum.com/showthread...hreadid=534799This portion of your formula:scott wrote:
gt;
gt; I would like to reference an IF formula to a specific cell. Similar to how a
gt; VLOOKUP references a certain cell. Is this possible? I tried this;
gt;
gt; =VLOOKUP(I3,DATA!1:65536,17)*IF(DATA!Q293=quot;CUSTOME R ERRORquot;,quot;Xquot;,)
gt; it returns a #VALUE!
gt;
gt; Any ideas?

--

Dave Peterson

This portion of your formula:

IF(DATA!Q293=quot;CUSTOMER ERRORquot;,quot;Xquot;,)

may return an X.

And you can't multiply by letters.

You may want to post more details about what you're doing.

scott wrote:
gt;
gt; I would like to reference an IF formula to a specific cell. Similar to how a
gt; VLOOKUP references a certain cell. Is this possible? I tried this;
gt;
gt; =VLOOKUP(I3,DATA!1:65536,17)*IF(DATA!Q293=quot;CUSTOME R ERRORquot;,quot;Xquot;,)
gt; it returns a #VALUE!
gt;
gt; Any ideas?

--

Dave Peterson

quot;scottquot; gt; wrote in message
...
gt;I would like to reference an IF formula to a specific cell. Similar to how
gt;a
gt; VLOOKUP references a certain cell. Is this possible? I tried this;
gt;
gt; =VLOOKUP(I3,DATA!1:65536,17)*IF(DATA!Q293=quot;CUSTOME R ERRORquot;,quot;Xquot;,)
gt; it returns a #VALUE!

Assuming that your VLOOKUP is coming up with a number, you're trying to
multiply it by text quot;Xquot; if the IF test is satisfied, hence the #VALUE
result.
If the IF test fails, your answer will be zero, as you haven't specified a
result for the false case.
--
David Biddulph