I have this long drawn out Index Match-ing formula that I am hoping can be shortened.
=ROUND((OFFSET(INDEX(K$1:K$2094,MATCH($A2304,$A$1:$A$2094,0)),6,0)*$D2304)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2305,$A$1:$A$2094,0)),6,0)*$D2305),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2306,$A$1:$A$2094,0)),6,0)*$D2306),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2307,$A$1:$A$2094,0)),6,0)*$D2307),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2308,$A$1:$A$2094,0)),6,0)*$D2308),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2309,$A$1:$A$2094,0)),6,0)*$D2309),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2310,$A$1:$A$2094,0)),6,0)*$D2310),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2311,$A$1:$A$2094,0)),6,0)*$D2311),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2312,$A$1:$A$2094,0)),6,0)*$D2312),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2313,$A$1:$A$2094,0)),6,0)*$D2313),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2314,$A$1:$A$2094,0)),6,0)*$D2314),0),0)
Please let me know
thanks
=ROUND((OFFSET(INDEX(K$1:K$2094,MATCH($A2304,$A$1:$A$2094,0)),6,0)*$D2304)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2305,$A$1:$A$2094,0)),6,0)*$D2305),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2306,$A$1:$A$2094,0)),6,0)*$D2306),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2307,$A$1:$A$2094,0)),6,0)*$D2307),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2308,$A$1:$A$2094,0)),6,0)*$D2308),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2309,$A$1:$A$2094,0)),6,0)*$D2309),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2310,$A$1:$A$2094,0)),6,0)*$D2310),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2311,$A$1:$A$2094,0)),6,0)*$D2311),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2312,$A$1:$A$2094,0)),6,0)*$D2312),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2313,$A$1:$A$2094,0)),6,0)*$D2313),0)+IFERROR((OFFSET(INDEX(K$1:K$2094,MATCH($A2314,$A$1:$A$2094,0)),6,0)*$D2314),0),0)
Please let me know
thanks