IF formulas

S

scott

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

Any ideas?
 
M

Morrigan

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

Any ideas?
Click to expand...


Suppose VLOOKUP() returns a number, you are trying to multiply a number
with a text string, which is not allowed.
 
D

Dave Peterson

This portion of your formula:

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

Any ideas?
Click to expand...
 
D

Dave Peterson

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.
 
D

David Biddulph

scott said:
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="CUSTOMER ERROR","X",)
it returns a #VALUE!
Click to expand...

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.
 
Top