Apr 14 2021 06:04 AM
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.
Apr 14 2021 06:54 AM
SolutionApr 14 2021 06:54 AM
SolutionA simple XLOOKUP():
=XLOOKUP(--LEFT(I1,3),$A$1:$A$17,$B$1:$B$17,"")