Index/Match modification maybe?

K

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
 
K

Ken

Don ... (Good morning)

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

Thanks ... Kha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/Match ... Repost from 05/10/07 2
Index/Match Lookup with a merged col 2
Min? 3
Reverse Unique Values 1
Index Formula Help 3
Index/Match vs VLookup? 4
Index/Match (maybe?) 9
Return every 50th Value? 6

Top