Index match combination

[rhhince]

Can someone help me clarify this equation.

=INDEX(SLOPE!D507606,MATCH(MIN(SLOPE!BI507:BI606),SLOPE!A507:A606))

I am asking excel to go to column D of the SLOPE workbook, match the
minimum of column BI.........All I get is the most current date.
Column D is a date, column BI is the minimum drop in equity. I wish to
retrieve the date of the minimum drop in equity from column BI.

Any help would be appreciated.

 

[T. Valko]

What does SLOPE!A507:A606 have to do with it?

In your explanation you mention D and BI but nothing about A?

Your formula is looking for the min from BI in A.

See if this does what you want:

=INDEX(SLOPE!D507606,MATCH(MIN(SLOPE!BI507:BI606),SLOPE!A507:A606,0))

 

[rhhince]

Thank you for your help. It worked, but only after I changed column A
to BI, which was what I should have had to start with. Column A has
absolutely no place in this equation. Thanx again.

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


Thank you for your help. It worked, but only after I changed column A
to BI, which was what I should have had to start with. Column A has
absolutely no place in this equation. Thanx again.

 

[Jacob Skaria]

I am not sure which site you use to post your queries. Would suggest to use
the Microsoft site itself.


http://www.microsoft.com/communitie...6ff-c721-4e5a-bfc7-0c8a35d71167&lang=en&cr=US


If this post helps click Yes