Index match combination
 

Can someone help me clarify this equation.

=INDEX(SLOPE!D507:D606,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.

Index match combination
 

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!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606,0))

--
Biff
Microsoft Excel MVP


"rhhince" wrote in message
...
Can someone help me clarify this equation.

=INDEX(SLOPE!D507:D606,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.

Index match combination
 

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.


On Apr 11, 11:41*am, "T. Valko" wrote:
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!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606,0))

--
Biff
Microsoft Excel MVP

"rhhince" wrote in message

...

Can someone help me clarify this equation.

=INDEX(SLOPE!D507:D606,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.

Index match combination
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"rhhince" wrote in message
...
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.


On Apr 11, 11:41 am, "T. Valko" wrote:
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!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606,0))

--
Biff
Microsoft Excel MVP

"rhhince" wrote in message

...

Can someone help me clarify this equation.

=INDEX(SLOPE!D507:D606,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.

Index match combination
 

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


http://www.microsoft.com/communities...&lang=en&cr=US


If this post helps click Yes
---------------
Jacob Skaria


"rhhince" wrote:

Can someone help me clarify this equation.

=INDEX(SLOPE!D507:D606,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.