SOLVED

Selection Extraction Insertion. Repeat

%3CLINGO-SUB%20id%3D%22lingo-sub-2272332%22%20slang%3D%22en-US%22%3ESelection%20Extraction%20Insertion.%20Repeat%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2272332%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%2C%20i%20am%20having%20some%20trouble%20(frankly%20i'm%20stucked)%20with%20automizing%20the%20work%20process.%20It%20consist%20in%20selecting%20certain%20cell%20information%20based%20on%20the%20information%20of%20other%20same-cell%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20sugestion%20in%20what%20direction%20to%20look%20for%20or%20what%20can%20be%20modified%20will%20be%20greatly%20apreciated.%20Thank%20you%20for%20your%20time%20on%20helping%20me%20with%20the%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERespectfully%2C%20Alexander.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel%20prob.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F272793iCF77B8987C9B8537%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel%20prob.png%22%20alt%3D%22excel%20prob.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2272332%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2272424%22%20slang%3D%22en-US%22%3ERe%3A%20Selection%20Extraction%20Insertion.%20Repeat%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2272424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1025909%22%20target%3D%22_blank%22%3E%40I_Wonder%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20simple%20XLOOKUP()%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DXLOOKUP(--LEFT(I1%2C3)%2C%24A%241%3A%24A%2417%2C%24B%241%3A%24B%2417%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

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.excel prob.png

2 Replies
best response confirmed by I_Wonder (New Contributor)
Solution

@I_Wonder 

A simple XLOOKUP():

=XLOOKUP(--LEFT(I1,3),$A$1:$A$17,$B$1:$B$17,"")
Works like a charm! Thank you!