I have three columns of Data. A is vehicle number, B is miles and C is a Date. I want to be able to pull the miles for the newest date when the user types in a bus number next to the formula. I think It can be done with an array formula but I am not 100% sure on how to do it. Any help would be appreciated. Also is it possible if they enter a vehicle number and a date that a different formula finds the miles for the most recent date to the date entered.

Thanks.

Monte

Excel Help.JPG