implementing an automatic formula change

  • Thread starter Thread starter mark
  • Start date Start date
M

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
 
Hi
try the following:
=HLOOKUP('Project Summary'!B1,'Associates Hours (actuals)'!
S5:AD200,COUNTA('Associates Hours (actuals)'!S5:S200),TRUE)
*30
 
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)
.
Click to expand...
 
Back
Top