Forum Discussion
Find Text in Cell that has multiple data
I'd do it like this:
In this example, the list in column R has just 3 items, but it can be as long as you wish - just modify the range in the formula accordingly.
The formula in I2 is
=IFERROR(INDEX($R$2:$R$4, MATCH(TRUE, ISNUMBER(SEARCH($R$2:$R$4, $H2)), 0)), "")
and this can be filled down.
Note: if you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter
I'd do it like this:
In this example, the list in column R has just 3 items, but it can be as long as you wish - just modify the range in the formula accordingly.
The formula in I2 is
=IFERROR(INDEX($R$2:$R$4, MATCH(TRUE, ISNUMBER(SEARCH($R$2:$R$4, $H2)), 0)), "")
and this can be filled down.
Note: if you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter
