Oct 11 2019 09:43 AM
I need help with a search if/then formula.
If Column A contains a keyword from Column E, the Value from Column F is copied to a blank Column B.
Oct 11 2019 09:58 AM
That could be
=IFNA(INDEX(F:F,MATCH(1,INDEX(ISNUMBER(SEARCH(E:E,A2))*(E:E<>""),0),0)),"no such")
in B2 and drag it down
Oct 11 2019 10:12 AM
@Sergei Baklan - Thank you so much! That worked
Oct 11 2019 01:23 PM
@KellyPoling , you are welcome