I did find a previous thread on this

https://www.excelforum.com/excel-for...ay-around.html

Your solution In E2 would be

Formula: copy to clipboard 
=IFERROR(LOOKUP(2^15,SEARCH($H$2:$H$5,D2),$I$2:$I$5),"Nope")


-
2020-09-10_9-54-24.jpg