Hi everyone.

My question has to do with the 2nd to last cell with data in a column. To
get the last data, I am using "=LOOKUP(10^100,A2:D2)" but how can I get the
data from the cell right above that?

For instance, my data looks like this (multiple tabs for different entities):

# of Accounts 1/1/10 45
$ of Accounts 1/1/10 6300
# of Accounts 1/2/10 23
$ of Accounts 1/2/10 1550

So, I want my totals page to show the last 2 entries (# and $).

TIA, any help would be wonderful,

Thanks,

Greg