I have the following index and match function for my sheet. The function
works just fine except that I would like to get the value right below this
one that is returned. Is there any way to tell excel to use this formula and
then go one row down and return that value? Do I need a macro?
=INDEX(DN!$A$8:$M$5594,MATCH('Sales Credit
Data'!$A13,DN!$A$8:$A$5594),MATCH('Sales Credit Data'!$D$9,DN!$A$8:$M$8))

Thanks for the help!

Hi

INDEX(Range,MATCH(...)+1,MATCH(...))


Arvi Laanemets



"John" wrote in message
...
I have the following index and match function for my sheet. The function
works just fine except that I would like to get the value right below this
one that is returned. Is there any way to tell excel to use this formula
and
then go one row down and return that value? Do I need a macro?
=INDEX(DN!$A$8:$M$5594,MATCH('Sales Credit
Data'!$A13,DN!$A$8:$A$5594),MATCH('Sales Credit Data'!$D$9,DN!$A$8:$M$8))

Thanks for the help!

thank you that works great.

"Arvi Laanemets" wrote:

Hi

INDEX(Range,MATCH(...)+1,MATCH(...))


Arvi Laanemets



"John" wrote in message
...
I have the following index and match function for my sheet. The function
works just fine except that I would like to get the value right below this
one that is returned. Is there any way to tell excel to use this formula
and
then go one row down and return that value? Do I need a macro?
=INDEX(DN!$A$8:$M$5594,MATCH('Sales Credit
Data'!$A13,DN!$A$8:$A$5594),MATCH('Sales Credit Data'!$D$9,DN!$A$8:$M$8))

Thanks for the help!