Hi Excel Expert,

Am trying to use index match to return value in column B based on matching 2 first chars on the left in column A.

Col A Col B
POS Majalt
POS Minalt
POS Instinctive
NB Viral
NB Sierra
NB Pierce
CLM Team1
CLM Team2
OS Tr1
OS Tr2
HR Tetra
HR Pentagon
IT penelope

Cell C1 : NBA MyFormula : {=INDEX(B:B,MATCH(LEFT(C1,2),"*"&$A:$A&"*",0))} <<== I need to find the match of NB only in range A:A to return the related values in Col B.

Expected Result:

NB Viral
NB Sierra
NB Pierce


Other than formula stated above, I've also tried with Isnumber(search), etc but all return errors. Can anyone help, pls?