# Looking for help with v or h lookups

#### pennstate710

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

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### kweaver

##### Well-known Member
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
on the best data image, the code is : =MAX('8-20'!C5:C32, '9-20'!C5:C32)

#### Attachments

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

#### kweaver

##### Well-known Member
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?

Replies
1
Views
69
Replies
1
Views
445
Replies
3
Views
176
Replies
4
Views
145
Replies
0
Views
75

### Forum statistics

Threads
1,127,588
Messages
5,625,668
Members
416,125
Latest member
NeedExcelHelp2021

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

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