You got this reply form Joseph McDaid over an hour ago in your post in
microsoft.public.excel. If you had no multi-posted this you may have
saved yourself the trouble of re-installing excel:

Quoted post:

surg4u197,

This is how excel behaves it is not just your copy.

Excel has no idea that the 3 in your formula should be tied to the
number of columns between column X and V. What your formula tells excel
is to return the 3rd column in the given range and this is what it
does. The work around i provided uses a formula that is sensitive to
the number of columns between column X and column V to adjust the
column offset to always resolve to the correct column.

In summary Excel only updates range references (A1:F6) for insertions
and deletions and not user entered assumptions (eg The number 3).

HTH

Joseph Mc Daid


Regards
Rowan

surg4u1975 wrote:
I just reloaded EXCEL using the repair function to no avail. This was
not an issue two days ago, and I think my company just loaded the
newest round of microsoft updates yesterday.

Anyone heard any issues with the latest round of updates?