How can I accomplish that?

Give us more information. What does your lookup function look like? Where
are the 6 values that you want returned?

Regards,
Fred

"brumanchu" wrote in message
...
Hello,
I am setting up a spreadsheet to return the last 6 values of a running
data
set.

I can get the rightmost value with the lookup function, but if I want to
constantly return only the last six values to trend on a chart, how can I
accomplish that?

Thanks for the help,
bruce