[Solved] Excel substitute for FIND Function when searching for multiple criteria

by


With you setup you would use INDEX/MATCH with your FIND as an array formuls:

=INDEX($D$1:$D$3,MATCH(TRUE,ISNUMBER(FIND($C$1:$C$3,A1)),0))

being an array formula it needs to be confirmed with Ctrl-Shift-Enter instead of Enter when exiting edit mode.

enter image description here

1

solved Excel substitute for FIND Function when searching for multiple criteria