Am following up on this...

Why is the optional last value a negative? Per MS support, it has to be positive.

http://support.microsoft.com/kb/324991
Enter the following formulas into cell E2 (or any available blank cell):

=OFFSET(C2,2,-1,1,1)

C2 - The referenced cell.

2 - Indicates the number of rows to move. Positive numbers mean move down, and negative numbers mean move up.

-1 - Indicates the number of columns to move. Positive numbers mean move to the right, and negative numbers mean move to the left.

1 (second last value) - (Optional.) Indicates how many rows of data to return. This number must be a positive number.

**1 (last value) - (Optional.) Indicates how many columns of data to return. This number must be a positive number.**