Cell auto update

[ajitexcel]

Index	date	starting Km (SK)	Closing Km (CK)	Total Km
1
2
3
4		first Km (FK)
5		Last Km (LK)
6		Progressive Km (PK)

<tbody>
</tbody>

Hello all

As enumerated above from 1-3 (upto 50 in actual file) individual enters daily starting Km and ending km, total km automatically gets updated for that day (CK - SK).
First Km (FK) also gets updated, now the problem starts I want Last KM(LK) to automatically update as individual enter CK so that Progressive KM (PK) i.e. LK - FK gets updated accordingly.
How do I do it.

 

[Andrew Poulsom]

Try eg:

=IFERROR(LOOKUP(9.99999999999999E+307,D2:D4),0)

 

[ajitexcel]

Thanks Andrew it worked as of now..
Regards..