Find Many String options in ONE String
Suppose you have these values in a range of cells:
D1 = ABC
D2 = (empty)
D3 = CC
D4 = BBC
A1 = ADFGBBC IIO
Formula entered as an array using the key combination of CTRL,SHIFT,ENTER
(not just ENTER):
=INDEX(D1:D4,MATCH(TRUE,ISNUMBER(SEARCH(IF(D1:D4< "",D1:D4),A1)),0))
Biff
"Nir" wrote in message
...
Hi,
I have an array where some of the cells contain strings and some are
blank.
I am looking for a formula that finds a string from the array within
another
string and resualts the string found.
e.g find within the array below a string in "ADFGBBC IIO" == result
should
be "BBC"
===
ABC
CC
BBC
===
thanks
|