Match a partial string with the match function

Hi guys,

I'm trying to get this snippet of code below working.

Please Login or Register  to view this content.

options is selected from a combobox in a userform and is declared as a string type variable

column one in the lookup range is filled as below

empty, "Option", empty, "P01-P03", "P02"

I have everything in the lookup range formatted as text as well. i can get it to return a 5 when the user selects "P02"
and a 5 when the user selects "P01" or "P02", but I need it to return a 4 when either "P01" or "P03" is selected.

any thoughts? thanks guys.

Try it like this:

Please Login or Register  to view this content.

Hope this helps.

Pete