Typically I want to extract the latest balance (the last figure) from a table of summed data which is sorted in ascending date order. Up to now, I have used the Index function, as in
INDEX(Table16[Column5],COUNTA(Table16[Column5])
but I always find Index unintuitive, so thought of the new Xlookup and easily and quickly came up with the formula
XLOOKUP(TODAY(),Table16[Column1]],Table16[Column5]],-1,-1))
The Index formula is more concise, and I wonder about calculation times. I find the Xlookup formula more intuitive to construct, but am I silly to use it in place of the more concise Index?
INDEX(Table16[Column5],COUNTA(Table16[Column5])
but I always find Index unintuitive, so thought of the new Xlookup and easily and quickly came up with the formula
XLOOKUP(TODAY(),Table16[Column1]],Table16[Column5]],-1,-1))
The Index formula is more concise, and I wonder about calculation times. I find the Xlookup formula more intuitive to construct, but am I silly to use it in place of the more concise Index?
Last edited: