This should be the easiest problem...ugh

J

jacob farino

I am trying the following formula:

=IF(C12="citifinancial",OFFSET(W17,MATCH(C12,X18:X20,0),0),"?")

Works Great. If the reference cell, c12 says Citifinancial, i get my matched
display. If it doesn't, I get a "?". Wonderful. But what I'm having a
difficult time with is the reference cell should be able to contain
Citifinancial OR Argent OR Novastar, for the matching formula to work, and
all other entries into C12 should return a "?".
But no matter how I write the OR statement, it doesn't work. I can only get
the reference cell to work with a single =. This should be easy right???
Any help would be terribly terribly appreciated.

jacob
 
D

Don Guillett

You didn't show us how you did it but an or statement is written as
or(cond1,cond2,cond3)
or(c12="a",c12="b",c12="c")
or even better
=IF(OR(C12={"a","b","c"}),1,2)
 
I

icestationzbra

from what you mention, you are only having an issue only with the O
part of it.

are you writing the OR part this way?

= IF ( OR (C12="CF", C12="A", C12="NS"), OFFSET (...), "?")

i have not tried the OFFSET part of your formula, but if you ar
writing the OR part this way, it should work..
 
Top