Looking for help with v or h lookups

[pennstate710]

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?

 

[kweaver]

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]

on the best data image, the code is : =MAX('8-20'!C5:C32, '9-20'!C5:C32)

 

[kweaver]

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?