LinkBack URL
About LinkBacks
Example is attached. I'm trying to dynamically pull the value of the cell either directly one or two cells to the right of a cell in an array. And the starting point in that array is based on a specified value. Below is a picture.
Capture.PNG
Example is attached. I'm trying to dynamically pull the value of the cell either directly one or two cells to the right of a cell in an array. And the starting point in that array is based on a specified value. Below is a picture.
Capture.PNG
Last edited by Barren_Wuffett; 09-09-2019 at 11:28 PM. Reason: [Solved]
=OFFSET(INDEX(G2:P2,1,MATCH(R2,G2:P2,0)),0,1)
Figured it out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks