ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using Vlookup to find last used number (https://www.excelbanter.com/excel-discussion-misc-queries/163885-using-vlookup-find-last-used-number.html)

Sunnyskies

Using Vlookup to find last used number
 
Morning from the Webb Ellis Cup Holders,

I have a list of vehicle registrations (column G), where the user enters the
opening (column N) and closing Kilometers (column O). Now users are not
always accurate, so I would like to use a vlookup that would in the opening
kilometers column, enter the last closing kilometes entered. This would
elimate errors on capturing.

Thanks

kassie

Using Vlookup to find last used number
 
Springbokke Rules!

contact me on j.kasselmanATlantic.net, but chnage the AT, maybe I can help?

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Sunnyskies" wrote:

Morning from the Webb Ellis Cup Holders,

I have a list of vehicle registrations (column G), where the user enters the
opening (column N) and closing Kilometers (column O). Now users are not
always accurate, so I would like to use a vlookup that would in the opening
kilometers column, enter the last closing kilometes entered. This would
elimate errors on capturing.

Thanks



All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com