# Getting value on a different tab (same spreadsheet)

#### britts614

##### New Member
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!

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### Fluff

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

#### britts614

##### New Member
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

##### MrExcel MVP, Moderator
Is the mileage in column B?

#### britts614

##### New Member

ADVERTISEMENT

Yes, the mileage is in column B.

#### Fluff

##### MrExcel MVP, Moderator
In that case change the format of the cell containing the formula to General

Thank you!

You're welcome

Replies
1
Views
152
Replies
2
Views
194

Threads
1,108,732
Messages
5,524,513
Members
409,583
Latest member
RedHelp