Assigning a numerical value based on one of six text strings

Dougal

Try this array entered (ctrl, shift, enter) formula

=MATCH(TRUE,ISNUMBER(SEARCH({"same","_1percent","_2pt5percent","_5percent_","_10percent_","_20percent_"},E4)),0)-1

If there is no match, it will return the #N/A error.


rylo