Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pat
 
Posts: n/a
Default 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   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display answer only in another cell of one containing a formula Mally Excel Discussion (Misc queries) 5 January 21st 05 02:07 PM
How to display gridlines at irregular intervals? Jason Weiss Charts and Charting in Excel 2 January 3rd 05 08:30 PM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 08:32 PM
Axis display as category doco Charts and Charting in Excel 4 December 12th 04 05:45 PM
Conditional display of a .jpeg file? sbhogle Excel Discussion (Misc queries) 2 November 30th 04 06:57 AM


All times are GMT +1. The time now is 11:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"