I am stuck in trying to find a solution to this and am reaching out to the pros for help.
I need to identify the previous (left) cell value based upon 1) locating a reference value in column A, 2) locating a reference value in columns B:I, 3) return a value on the left of the reference from columns B:I.
From the attached, I want to find "19d0181" in column A and find "CUT" in columns B:K, while returning "LAM".
I'm stumped on this one and really could use some help.
Bookmarks