Find ROW which formula calculated answer from

[pabloboswell]

Hello,

I have a fairly complicated formula that is giving me the answer I want; however, I cannot for the life of me get Excel to show me which 2 values the formula actually used to get the answer.

Here is the formula:

={MAX(OFFSET(WTI_prices!$A$1,1,MATCH(Sheet1!$G$1,WTI_prices!$B$1:$M$1),3497,1)-OFFSET(WTI_prices!$A$1,1,MATCH(Sheet1!$C$1,WTI_prices!$B$1:$M$1),3497,1))}

Essentially, this goes through the entire array and finds the maximum difference between two numbers found in two different columns but within the same row.

At this point, I need to know which row the formula is using in order to then create a formula to display the date that corresponds to that row (dates are in column A).

Any ideas?

[pabloboswell]

I tried using the INDEX function, but there seems to be a problem because my original formula uses two columns to find the answer (BUT they are in the same row). How do I get around this?