Thread: [Solved] Looking for certain words in a string
View Single Post
 
Old 08-08-2019, 05:44 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Does this Array* formula work?


=INDEX(BeadTypes!$A$2:$A$12, MATCH(MIN(IFERROR(SEARCH(BeadTypes!$A$2:$A$12,D2), "x")), IFERROR(SEARCH(BeadTypes!$A$2:$A$12,D2),"x"),0))


*you must confirm the formula with CTRL+SHIFT+ENTER not just ENTER, then copy down.

#N/A means no matches found.
Reply With Quote