Hi Walter,

Am Tue, 25 Jun 2013 13:03:04 +0100 schrieb Walter Briscoe:

Does the behavior, I reported with OFFSET exist in newer versions
[2003+] of Microsoft Excel?

the first argument (base) of OFFSET has to be a reference.
For your wishes you can use it so:
=OFFSET($A$1,,A2)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2