08-09-2019, 12:09 PM
|
|
The Formula Guy
|
|
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
|
|
Quote:
Originally Posted by Guinness
My question was why that formula didn't return "glass" when "glass" was in the string. Most of the others are returning the correct word based on the list on the "Bead" tab, but I couldn't see any reason why it was returning shell if glass was the first bead type in the string.
|
That is why I gave you the alternate formula in your other thread: https://www.msofficeforums.com/excel...ds-string.html
=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))
this one finds the first occurance in the string. The LOOKUP() formula finds the last.
|