Thread: Identifying text in a string
View Single Post
  #3   Report Post  
otteraaron otteraaron is offline
Junior Member
  
Posts: 2
Default
That works!! THANK YOU!!

Quote:
Originally Posted by Kevin@Radstock View Post
Hi otteraaron

Try the following in C1 and copy down to C5:

=LOOKUP(20^20,SEARCH($B$1:$B$3,$A1),$B$1:$B$3)

Kevin
Reply With QuoteReply With Quote