Search Text of Cell in a range and return the contents

Hi Knowing,

Use the below formula :-

Formula:

=INDEX($B$1:$B$14,MIN(IF(ISNUMBER(SEARCH($A2,$B$2:$B$14)),ROW($B$2:$B$14),"")))

Enter this using Ctrl Shift Enter key combination.


See attached:- Book1.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>