Getting value on a different tab (same spreadsheet)

britts614

New Member
Joined
Jul 9, 2019
Messages
8
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!
 

Some videos you may like

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
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
How about
=LOOKUP(2,1/(Sheet2!B2:B19<>""),Sheet2!B2:B19)
 

britts614

New Member
Joined
Jul 9, 2019
Messages
8
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
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
Is the mileage in column B?
 

britts614

New Member
Joined
Jul 9, 2019
Messages
8

ADVERTISEMENT

Yes, the mileage is in column B.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
In that case change the format of the cell containing the formula to General
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,134
Office Version
  1. 365
Platform
  1. Windows
You're welcome
 

Watch MrExcel Video

Forum statistics

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

This Week's Hot Topics

Top