Hi everyone.
I am pretty new to excel but have been doing ok often due to help from MrExcel members.
I am trying to return a number based on two criteria using the following array formula.
=INDEX($D$2:$D$2000,MATCH($A2,$D2:$D$2000,0)*MATCH($L$2,$I$2:$I$2000,0))
I have entered it using shift and ctrl but it doesn't work, i get #N/A or 0 but not the return from column D that i want.
Hopefully something silly will be obvious to one of you and i can fix it quickly.
Thanks in advance.
Paul
I am pretty new to excel but have been doing ok often due to help from MrExcel members.
I am trying to return a number based on two criteria using the following array formula.
=INDEX($D$2:$D$2000,MATCH($A2,$D2:$D$2000,0)*MATCH($L$2,$I$2:$I$2000,0))
I have entered it using shift and ctrl but it doesn't work, i get #N/A or 0 but not the return from column D that i want.
Hopefully something silly will be obvious to one of you and i can fix it quickly.
Thanks in advance.
Paul