implementing an automatic formula change

[mark]

Could anyone tell me if it is possible to implement an
automatic change to a HLOOKUP formula on insertion of a
new row? When i create a new row i need to increase the
number 72 in the forula below to 73, otherwise the correct
value will not be picked up.

=HLOOKUP('Project Summary'!B1,'Associates Hours
(actuals)'!S5:AD76,72,TRUE)*30

 

[Frank Kabel]

Hi
try the following:
=HLOOKUP('Project Summary'!B1,'Associates Hours (actuals)'!
S5:AD200,COUNTA('Associates Hours (actuals)'!S5:S200),TRUE)
*30

 

[Guest]

Unfortunately that only returns Jan-00????

-----Original Message-----
Hi
try the following:
=HLOOKUP('Project Summary'!B1,'Associates Hours (actuals)'!
S5:AD200,COUNTA('Associates Hours (actuals)'! S5:S200),TRUE)
.

 

[Frank Kabel]

Hi
what values do you have in column S?. And do you have blank rows in
between?