Can anyone advise on how to do a lookup that picks up the previous value in a column in a table ?
The value will be repeated several times in the table and I want to refer to the last occurrence. The table is not sorted and the most recent data is added to the bottom of the spreadsheet.
All the lookup funstions seem to pick up the first instance of the data - how do I get a reference to the last ?
Thanks
The value will be repeated several times in the table and I want to refer to the last occurrence. The table is not sorted and the most recent data is added to the bottom of the spreadsheet.
All the lookup funstions seem to pick up the first instance of the data - how do I get a reference to the last ?
Thanks