Selection Extraction Insertion. Repeat

[I_Wonder]

Good day, i am having some trouble (frankly i'm stucked) with automizing the work process. It consist in selecting certain cell information based on the information of other same-cell rows.

Any sugestion in what direction to look for or what can be modified will be greatly apreciated. Thank you for your time on helping me with the issue.

Respectfully, Alexander.

[#2 · Accepted solution]

@I_Wonder 

A simple XLOOKUP():

=XLOOKUP(--LEFT(I1,3),$A$1:$A$17,$B$1:$B$17,"")

[#3]

Works like a charm! Thank you!