Thank you. This is what I have so far:
=INDEX(SALES,MATCH(TODAY(),SALE_DATE,1),MATCH
(O4,O13:T13,0))
This works fine for the last entry. I now need the next
previous entry, which may have the same date. Any help?
Thank You.
-----Original Message-----
why not use match to find the last row and then -1, -2,-
3,-4 and then use
index for the column
--
Don Guillett
SalesAid Software
"Ben" wrote in
message
...
I am trying to build a lookup table to extract the last
five entries in a list. As data is entered, I want the
table to update itself. Could someone point me in the
right direction?
Thank You.
|