How to report a bug
Sadly, I cannot replicate your problem. If I put your formula in a cell and
copy downwards, I get:
=VLOOKUP($A3,pvt90DNet!$A:$AZ,MATCH(pvt90DNet!B$2, pvtCnt90!$2:$2,0))
=VLOOKUP($A4,pvt90DNet!$A:$AZ,MATCH(pvt90DNet!B$2, pvtCnt90!$2:$2,0))
=VLOOKUP($A5,pvt90DNet!$A:$AZ,MATCH(pvt90DNet!B$2, pvtCnt90!$2:$2,0))
=VLOOKUP($A6,pvt90DNet!$A:$AZ,MATCH(pvt90DNet!B$2, pvtCnt90!$2:$2,0))
=VLOOKUP($A7,pvt90DNet!$A:$AZ,MATCH(pvt90DNet!B$2, pvtCnt90!$2:$2,0))
=VLOOKUP($A8,pvt90DNet!$A:$AZ,MATCH(pvt90DNet!B$2, pvtCnt90!$2:$2,0))
The $A3 adjusts as it should. $2:$2 retains its integrity.
Same behavior in 2003 & 2007
--
Gary''s Student - gsnu200829
"PJFry" wrote:
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?
|