Forum Discussion
Returning the last value of a row to another cell
Hi team, Could someone help with a formula to return values from a range of cells to a particular cell depending on dates. For example, the last cell value of that row is always copied to another c...
The question is somewhat ambiguous. Firstly, the dates came over Jan 1 to Jan 10. Is that what was intended or should it be read as the 1st of each month from Jan-Oct?
What is the 'latest' date? Is it 1st Aug since we are now in August, or the 1st Oct since that is the last date in the table?
A possible answer (assuming the labels 'date' and 'value' are applied to the series as names
= LOOKUP( TODAY(), Date, Values )or with modern Excel
= XLOOKUP( TODAY(), Date, Values, , -1 )
Thanks Peter.