One way:

Assume your list is in A1:Ax, with no blanks. The last 5 entries can be
returned by selecting 5 cells in another column and array-entering
(CTRL-SHIFT-ENTER or CMD-RETURN):

=OFFSET(A1,COUNTA(A:A)-5,0,5,1)

Note: this fails if there are less than 5 items in column A.

In article ,
"Ben" wrote:

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.