Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Display result as Yes or No
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))) |
#2
|
|||
|
|||
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(PurOrders0 4!H415,ReferanceLists!$G$6 :$G$1500,0)) & " Second is " & INDEX(ReferanceLists!$K$6:$K$1500,MATCH(PurOrders0 4!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 "Pat" wrote in message ... 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))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
How to display gridlines at irregular intervals? | Charts and Charting in Excel | |||
Amount or Numbers in Words | New Users to Excel | |||
Axis display as category | Charts and Charting in Excel | |||
Conditional display of a .jpeg file? | Excel Discussion (Misc queries) |