Display result as Yes or No

[Pat]

The following formula has been modified to include an "or" to return a
result from 2 ranges. I do not know what I am trying to do is possible. When
there is a result to return I want to format the cell to return "yes" or
"no". Is this possible?


=IF(ISERROR(INDEX(ReferanceLists!$J$6:$J$1500,or,ReferanceLists!$K$6:$K$1500
,MATCH(PurOrders04!H415,ReferanceLists!$G$6:$G$1500,0))),"",INDEX(ReferanceL
ists!$J$6:$J$1500,or,ReferanceLists!$K$6:$K$1500,MATCH(PurOrders04!H415,Refe
ranceLists!$G$6:$G$1500,0)))

 

[Bernie Deitrick]

Pat,

The formula may have been modified, but you didn't modify it correctly:
OR() is a function that takes arguments, not an operator that is offset by
commas.

Here's my best guess at what you want to do:
=IF(ISERROR(MATCH(PurOrders04!H415,ReferanceLists!$G$6:$G$1500,0)),"No","Yes
")

If you actually want the values returned:

=IF(ISERROR(MATCH(PurOrders04!H415,ReferanceLists!$G$6:$G$1500,0)),"No",
"Yes. First is " &

INDEX(ReferanceLists!$J$6:$J$1500,MATCH(PurOrders04!H415,ReferanceLists!$G$6
:$G$1500,0))
& " Second is " &
INDEX(ReferanceLists!$K$6:$K$1500,MATCH(PurOrders04!H415,ReferanceLists!$G$6
:$G$1500,0)))

PS. It's usually better to spell "Reference"correctly - the boss will
appreciate it.

HTH,
Bernie
MS Excel MVP