I find that in Excel 2003 and Excel 2007
=VLOOKUP($A3,Sheet4!$A:$AZ,MATCH(Sheet4!B$2,Sheet4 !2:$2,0))
becomes
=VLOOKUP($A4,Sheet4!$A:$AZ,MATCH(Sheet4!B$2,Sheet4 !$2:3,0))
Note the $ before the $2:3
But if you start with $2:$2 it stays that way
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"PJFry" wrote in message
...
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?