Getting value on a different tab (same spreadsheet)

[britts614]

Hello,

I’m trying to display the latest value entered on adifferent tab (pretty much a Vlookup example).
In the column on “Tab_2” an employee enters the new amountof mileage driven in the rented car once it’s returned (see example below. Date and Mileage are two different columns):

“Date”........................“Mileage”

01/01/2019................123,456
01/05/2019 ...............123,557
01/27/2019 ...............124,896
01/31/2019 ..................?

On the “Tab_1” page I need to display the most recentmileage count. So, if it displays “124,896” on “Tab_1”, I will need to see the “?”when they enter the mileage on 01/31/2019.

I’ve been trying to use Vlookup for this but I am makingerrors. Does this make sense?
Please help!

 

[Fluff]

Hi & welcome to MrExcel.
How about
=LOOKUP(2,1/(Sheet2!B2:B19<>""),Sheet2!B2:B19)

 

[britts614]

Hi & welcome to MrExcel.
How about
=LOOKUP(2,1/(Sheet2!B2:B19<>""),Sheet2!B2:B19)

Thanks for your response!

It doesn't seem to be working but I think it's close. It gives me the value of a date instead of the mileage.

 

[Fluff]

Is the mileage in column B?

 

[britts614]

Yes, the mileage is in column B.

 

[Fluff]

In that case change the format of the cell containing the formula to General

 

[britts614]

Thank you!

 

[Fluff]

You're welcome