Looking for help with v or h lookups

pennstate710

New Member
Joined
Jul 25, 2017
Messages
3
Let me start by saying I am a pretty newbie to Excel - I know the basics but V/H lookups are out of my capabilities.

What I am looking to do: I have bike mile logs on two sheets and on a third are thee highest or max for a particular stat. I was able to create the max sheet but what i would like to do is have a formula also find the date that the "max" stat took place. The two names of the sheets with data are '8-20' and '9-20'. Does anyone know of a way to get these dates from the max stat?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,450
Office Version
  1. 365
  2. 2010
It would be helpful to use XL2BB to show us sample data.
If you personally want to continue experimenting with VLOOKUP (assuming you don't have 365) then be sure you're following the syntax.
VLOOKUP looks in the first column and finds a subsequent column of your choosing.
 

pennstate710

New Member
Joined
Jul 25, 2017
Messages
3
on the best data image, the code is : =MAX('8-20'!C5:C32, '9-20'!C5:C32)
 

Attachments

  • August Data.png
    August Data.png
    37.2 KB · Views: 3
  • Best Data.png
    Best Data.png
    5.6 KB · Views: 3

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,450
Office Version
  1. 365
  2. 2010
Please use XL2BB so that we don't have to retype your data to test and try to find a solution. Where is your formula and what formula do you need and where do you want it? What expected answer(s) do you want?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,514
Messages
5,602,089
Members
414,501
Latest member
mdhaumyu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top