Min Max VLookup Excel 2013

[MrDB4Excel]

The attached images portray an Excel worksheet where I track Currency Exchange Rates. I have tried in vain many variations of VLookup and cannot seem to get it right. What I need is for the relevant date per the MAX and MIN values to auto insert into the indicated cells as seen in the images. The small blue colored dates you see in the images were input manually for example by entering into the cell 5/15/2020. I want these dates to appear automatically based on the lookup. Thanks for any help offered. This first image, showing =MAX(C12:C364), is in the cell E7. Directly above E7, in E6 is where I want the date associated with the Max value, as seen in the image in Cell B22, to appear. Obviously, as data is entered, then the MAX and MIN values will update accordingly as will the associated dates.
The cells that show "This Row Shows Minimum Exchange Rate" and "This Row Shows Maximum Exchange Rate" I have edited in the worksheet after creating the images to say "This Row Shows Cell Location of Minimum Exchange Rate" and "This Row Shows Cell Location of Maximum Exchange Rate"
View attachment 14105View attachment 14106View attachment 14107

 

[jasonb75]

VLOOKUP can't retrieve the dates based on the value unless you move the dates to another column. For you layout you need INDEX and MATCH, where dates and values refer to the relevant columns in your data.

=INDEX(dates,MATCH(MIN(values),values,FALSE))

 

[MrDB4Excel]

VLOOKUP can't retrieve the dates based on the value unless you move the dates to another column. For your layout, you need INDEX and MATCH, where dates and values refer to the relevant columns in your data.

=INDEX(dates,MATCH(MIN(values),values,FALSE))

By moving the dates to another column are you referring to for example the dates above the cell location designations as in the date in E6 needs to be in say, for example, the "X" column as seen here in this third image?

 

[MrDB4Excel]

I am having difficulty with the formula. I entered this formula into column "Y" so that the result is in a different column than the MIN value result: =INDEX($B$12:B364,MATCH(MIN($C$12:C364),$B$12:B364,FALSE))... the result returns #N/A

 

[jasonb75]

By moving the dates to another column are you referring to for example the dates above the cell location designations as in the date in E6 needs to be in say, for example, the "X" column as seen here in this third image?

No, the whole column of dates would need to be moved to the right of the columns with the values. The value that you want to look for (min or max) must always be in the left hand column, this information is in the help file.

=INDEX($B$12:B364,MATCH(MIN($C$12:C364),$B$12:B364,FALSE))... the result returns #N/A

If you check the example formula then you will see that it uses the values twice and the dates only once, not the values once and the dates twice as you have done.

 

[MrDB4Excel]

Many thanks, works perfectly