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!