One way

Source data assumed in sheet: B, cols A to C
where
col A = real dates
col B = vehicle ids
col C = mileage figs

In sheet: A,
With vehicle ids listed in A2 down
Put in B2, array-enter, ie press CTRL+SHIFT+ENTER to confirm the formula:
=INDEX(B!C$2:C$10,MATCH(MAX(IF(B!B$2:B$10=A2,B!A$2 :A$10)),IF(B!B$2:B$10=A2,B!A$2:A$10),0))
Copy down to extract the required latest mileage fig (by the dates in B's
col A) for the vehicle ids listed in A2 down. Adapt the ranges to suit the
extents of your actuals.

Real dates are just nums, so the "max" date for that vehicle id = latest date
High-five? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Resi" wrote:
is there a formula which allows me to update a cell in a different worksheet
in the same workbook, with the latest/highest value entered in a different
worksheet?

example:
worksheet B has got chronological listing of mileage related to different
vehicles and drivers.
in worksheet A I like to have the vehicle in cell A2 with it's latest
mileage reading in cell B2, where the criteria will be cell A2.

hi Max
thanks for your answer! took me a while to work out what it was! but, still
gives me an asnwer as n/a...
any idea?
r

"Max" wrote:

One way

Source data assumed in sheet: B, cols A to C
where
col A = real dates
col B = vehicle ids
col C = mileage figs

In sheet: A,
With vehicle ids listed in A2 down
Put in B2, array-enter, ie press CTRL+SHIFT+ENTER to confirm the formula:
=INDEX(B!C$2:C$10,MATCH(MAX(IF(B!B$2:B$10=A2,B!A$2 :A$10)),IF(B!B$2:B$10=A2,B!A$2:A$10),0))
Copy down to extract the required latest mileage fig (by the dates in B's
col A) for the vehicle ids listed in A2 down. Adapt the ranges to suit the
extents of your actuals.

Real dates are just nums, so the "max" date for that vehicle id = latest date
High-five? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Resi" wrote:
is there a formula which allows me to update a cell in a different worksheet
in the same workbook, with the latest/highest value entered in a different
worksheet?

example:
worksheet B has got chronological listing of mileage related to different
vehicles and drivers.
in worksheet A I like to have the vehicle in cell A2 with it's latest
mileage reading in cell B2, where the criteria will be cell A2.

gives me an answer as n/a ...

That's because you didn't confirm the formula correctly. "Array-enter" means
to press CTRL+SHIFT+ENTER (CSE) to confirm the formula, instead of just
pressing ENTER. When it's done correctly, Excel will wrap curly braces { }
around the formula, which you can see inside the formula bar. Do sight this
as a visual check that the formula is correctly array-entered. If you don't
see the curlies, then it isn't array-entered, and it won't return the correct
results. Click inside the formula bar again, and re-do the CSE. Then re-check
for the curlies. It should work fine.

Celebrate success? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Resi" wrote:
hi Max
thanks for your answer! took me a while to work out what it was! but, still
gives me an asnwer as n/a...
any idea?

i did I did! ;o)
yes the curlies are there in but still n/a as an answer...

"Max" wrote:

gives me an answer as n/a ...

That's because you didn't confirm the formula correctly. "Array-enter" means
to press CTRL+SHIFT+ENTER (CSE) to confirm the formula, instead of just
pressing ENTER. When it's done correctly, Excel will wrap curly braces { }
around the formula, which you can see inside the formula bar. Do sight this
as a visual check that the formula is correctly array-entered. If you don't
see the curlies, then it isn't array-entered, and it won't return the correct
results. Click inside the formula bar again, and re-do the CSE. Then re-check
for the curlies. It should work fine.

Celebrate success? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Resi" wrote:
hi Max
thanks for your answer! took me a while to work out what it was! but, still
gives me an asnwer as n/a...
any idea?

"Resi" wrote:
.. yes the curlies are there in but still n/a as an answer...

Then it points to your data quality. Either you don't have real* dates in
B's col A and/or your vehicle ids** are not consistent between sheets A and
B.