| 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))) |
| 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) | |||
Threaded Mode
