IF formulas
 

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="CUSTOME R ERROR","X",)
it returns a #VALUE!

Any ideas?

IF formulas
 

scott Wrote:
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="CUSTOME R ERROR","X",)
it returns a #VALUE!

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: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=534799

IF formulas
 

This portion of your formula:


scott wrote:

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="CUSTOME R ERROR","X",)
it returns a #VALUE!

Any ideas?

--

Dave Peterson

IF formulas
 

This portion of your formula:

IF(DATA!Q293="CUSTOMER ERROR","X",)

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:

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="CUSTOME R ERROR","X",)
it returns a #VALUE!

Any ideas?

--

Dave Peterson

IF formulas
 

"scott" wrote in message
...
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="CUSTOME R ERROR","X",)
it returns a #VALUE!

Assuming that your VLOOKUP is coming up with a number, you're trying to
multiply it by text "X" 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