Hello,

I had the following formula (which works fine for exact matching):

=INDEX(B:B;MATCH(F2;A:A;0))

This time I need a partial match and not exact match. For example match "BO" from "BO635E30X". The scenario is always first text from left before numbers. Another example is "K" from "K5450X". It needs to always match the first letters before any numbers.

Your help will be much appreciated.