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.