Look Up Function For Date

MrDB4Excel

Active Member
Joined
Jan 29, 2004
Messages
348
Office Version
  1. 2013
Platform
  1. Windows
Get Date From Column C Matching Row Of Max Value
I have an Excel spreadsheet where I save history of currency exchange rates.
In one cell I inserted the formula =MAX(A:A). This gets the maximum exchange rate appearing in that column.
In another cell I inserted the formula =CELL("address",INDEX(A:A,MATCH(MAX(A:A),A:A,0))).
I will name this result as $A&182, which is what this Excel sheet has indicated is the location of the maximum exchange rate.
This tells me what cell this maximum exchange rate is located.
I have another column that displays the date for which the indicated exchange rate was queried from the web.
Following is an example from this Excel sheet.
Column A Column B Column C
Exchange Rate Time Date
22.69832 21:11:11 Wednesday--24 Oct 2018
What I want to do is be able to get the date of the exchange rate that appears in the row 182 of this result $A$182 to appear in another cell close to the cell that reports $A$182.
Example of existing cells in my sheet as follows:
Maximum Value in Exchange Rate Column >>> 22.7114200 Location >>> $A$182
What I want is an additional cell to say:
Date of Maximum Exchange Rate Value >>>
Obviously somehow Excel would look in column C for the data that correlates with the same row of the maximum exchange rate value and return that find to the cell next to the cell that says: Maximum Value in Exchange Rate Column >>>
Thanks in advance for any good working resolution.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,223,905
Messages
6,175,297
Members
452,633
Latest member
DougMo

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
Back
Top