Hello, I'm using this vlookup offset code to find out which is the last number of the column.
=OFFSET(INDEX(O2:W2,MATCH(A2,O2:W2,0)),COUNT(O:O),0,1)
The code works, but instead of giving me the last number it gives me the number before the last. What am I doing wrong?
Name of the column is #E - Difference from.
Bookmarks