Index/Match modification maybe?

[Ken]

Excel2003 ...

Col A ... Text format ... contents alpha-numeric & may repeat
Col B ... Text format ... contents alpha-numeric & may repeat
(note: Col B sorted in Ascending order)
(note: length of Col A & B Cell contents & # of repeats is random)

Col L ... I am using INDEX/MATCH to find value in Col B, return Value in Col
A.

Formula working fine except when value in Col B repeats ... Issue is ... My
INDEX/MATCH formula is returning 1st value found in Col A (Q5X) ... What I
need when a match is found in Col B ... is the value returned from Col A that
looks like a number. For the example below ... I wish Col A value of 123 to
be returned.

Col A ...... Col B
Q5X ....... 1A5637
C6Y ........ 1A5637
123 ........ 1A5637
X2Z ........ 1A5637

Thank you for the guidance ... Kha

 

[Don Guillett]

As ALWAYS, post YOUR efforts for comments.

 

[Ken]

Don ... (Good morning)

If my original Post missed a Board protocol??? Can you further explain?

Thanks ... Kha