Index Match and Extract

[lai_arceo]

Good day.

I know how to basically do an index match search. However, I am stumped on how to extract the first, 2nd, 3rd, 4th and fifth letters of the returned value.

A sample is attached below. I need to be able to enter the ID number and then generate the FIRST NAME INITIALS of the returned value. Any help will be much appreciated.

 

[SunnyAlv]

Your excel version 2019 right?
Try this and please include your excel version in your BIO,

Cell F2

=IFERROR(MID(INDEX(B2:B4,MATCH(D2,A2:A4,0)),{1,2,3,4,5,6,7},1),"")

 

[lai_arceo]

Your excel version 2019 right?
Try this and please include your excel version in your BIO,

Cell F2

=IFERROR(MID(INDEX(B2:B4,MATCH(D2,A2:A4,0)),{1,2,3,4,5,6,7},1),"")

View attachment 106381

Worked perfectly, thank you so much!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have 2021 or 365 you could use this

=LET(x,XLOOKUP(D2,A2:A4,B2:B4,""),IF(x="","",MID(x,SEQUENCE(,LEN(x)),1)))