Thomas Kuriakose
Active Member
Respected Sirs,
I am not able to get an index match or lookup working with a drop down list selection.
Attached is a workbook with three trials of index match to lookup values in K3&K4 in range E4:I8 and provide the result which needs to be multiplied by L3.
1. =INDEX(E4:I8,MATCH(K3,$E$3:$I$3,0),MATCH(K4,$D$4:$D$8,0))*L3 - gives the result for values in E4:E7, but does not give the values from E8:I8.
2. =IFERROR(INDEX(E4:I8,MATCH(K3&K4,INDEX(E3:I3&D4:D8,,),0)),0)*L3 - all results are zero
3. =INDEX(E4:I8,MATCH(K3&K4,E3:I3&D4:D8,0)) - returns #N/A
I am not able to get an index match or lookup working with a drop down list selection.
Attached is a workbook with three trials of index match to lookup values in K3&K4 in range E4:I8 and provide the result which needs to be multiplied by L3.
1. =INDEX(E4:I8,MATCH(K3,$E$3:$I$3,0),MATCH(K4,$D$4:$D$8,0))*L3 - gives the result for values in E4:E7, but does not give the values from E8:I8.
2. =IFERROR(INDEX(E4:I8,MATCH(K3&K4,INDEX(E3:I3&D4:D8,,),0)),0)*L3 - all results are zero
3. =INDEX(E4:I8,MATCH(K3&K4,E3:I3&D4:D8,0)) - returns #N/A