The formula starts off like so:
=VLOOKUP($A3,pvt90DNet'!$A:$AZ,MATCH('pvt90DNet'!B $2,'pvtCnt90'!$2:$2,0)

But when I copy it down the range, the lookup array for the match loses its
fixed reference, like so:
=VLOOKUP($A3,pvt90DNet'!$A:$AZ,MATCH('pvt90DNet'!B $2,'pvtCnt90'!2:2,0)

If I go back and re-fix the reference and copy it down, no issues. If make
a change to the formula and copy it down the range, the references are no
longer fixed again.


"Gary''s Student" wrote:

Post a description of you bug here and get some feedback
--
Gary''s Student - gsnu200829


"PJFry" wrote:

I have found a bug using the Match function in Excel 2007 and I want to see
if it has already been reported. How can I do that?