How can I drag a vlookup formula to look at the same range but change the colom index by 1 increment to refer to the corresponding colom? --- I tried Index Match too
Example; vlookup(A2, C2:G5, 2, false) should change to vlookup(A2, C2:G5, 3, false) for the next colom I drag it to etc.
I have attached example file. Tracker tab is pulling shift time according to date with one minute leeway to make way for lateness.
Bookmarks