Search Text of Cell in a range and return the contents

yes.. for multiple column search, you can play with the formula part MIN(IF(ISNUMBER(SEARCH($A2,$B$2:$B$14)),ROW($B$2:$B$14),""))

Regards,
DILIPandey

<click on below 'star' if this helps>