showing results from more than one cell

[Michelle Tucker]

Bernie,

Thanks for the reply - doesn't seem to be working, and I don't know enough
about OFFSET and MATCH to try and correct!
Any ideas?

Michelle,

Oops, sorry that I overlooked your "slash" requirement: a little longer
yet....

=IF(COUNTIF(D2428,"*MT*"),INDEX($A24:$A28,MATCH("*MT*",D2428,FALSE)),"DA
Y OFF")&
IF(COUNTIF(D2428,"*MT*")=2,"/" &
INDEX(OFFSET($A24:$A28,MATCH("*MT*",D2428,FALSE),0,5,1),MATCH("*MT*",OFFSE
T(D2428,MATCH("*MT*",D2428,FALSE),0,5,1),FALSE)),"")

HTH,
Bernie
MS Excel MVP

Expand AllCollapse All

Manage Your Profile
©2004 Microsoft Corporation. All rights reserved. Terms of Use |Trademarks
|Privacy Statement