Hi,

In copying this formula:

=VLOOKUP(E$42,IData!$E$3:$AY$65536,35,FALSE)

from one column to another, regular copy and paste, it treats e$42 as if it
is $e$42. If I copy and paste special, formulas and number formats, it will
update the column reference correctly.

Does anyone know if this is a known bug? Do you have this problem as well?
Not sure where to post possible problems so thought I'd try here as well as
mailing MS directly.

Thank you,
Deb