Index/Match modification maybe?
 

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

Index/Match modification maybe?
 

As ALWAYS, post YOUR efforts for comments.

--
Don Guillett
SalesAid Software

"Ken" wrote in message
...
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

Index/Match modification maybe?
 

Don ... (Good morning)

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

Thanks ... Kha

"Don Guillett" wrote:

As ALWAYS, post YOUR efforts for comments.

--
Don Guillett
SalesAid Software

"Ken" wrote in message
...
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