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,R eferanceLists!$K$6:$K$1500
,MATCH(PurOrders04!H415,ReferanceLists!$G$6:$G$150 0,0))),"",INDEX(ReferanceL
ists!$J$6:$J$1500,or,ReferanceLists!$K$6:$K$1500,M ATCH(PurOrders04!H415,Refe
ranceLists!$G$6:$G$1500,0)))