Hello All,

Would anyone be able to help me write the following formula as an array formula. I can't figure it out with vlookup:

=AV$5/$BH$19*$F$46/((IFERROR(VLOOKUP($D$25,DL!$AE$2:$AG$16,3)*$G$25,0)+IFERROR(VLOOKUP($D$26,DL!$AE$2:$AG$16,3)*$G$26,0)+IFERROR(VLOOKUP($D$27,DL!$AE$2:$AG$16,3)*$G$27,0)+IFERROR(VLOOKUP($D$28,DL!$AE$2:$AG$16,3)*$G$28,0)+IFERROR(VLOOKUP($D$29,DL!$AE$2:$AG$16,3)*$G$29,0)+IFERROR(VLOOKUP($D$30,DL!$AE$2:$AG$16,3)*$G$30,0)+IFERROR(VLOOKUP($D$31,DL!$AE$2:$AG$16,3)*$G$31,0)+IFERROR(VLOOKUP($D$32,DL!$AE$2:$AG$16,3)*$G$32,0)+IFERROR(VLOOKUP($D$33,DL!$AE$2:$AG$16,3)*$G$33,0)+IFERROR(VLOOKUP($D$34,DL!$AE$2:$AG$16,3)*$G$34,0)+IFERROR(VLOOKUP($D$35,DL!AC$2:$AE$16,3)*$G$35,0)+IFERROR(VLOOKUP($D$36,DL!$AE$2:$AG$16,3)*$G$36,0)+IFERROR(VLOOKUP($D$37,DL!$AE$2:$AG$16,3)*$G$37,0)+IFERROR(VLOOKUP($D$38,DL!$AE$2:$AG$16,3)*$G$38,0)+IFERROR(VLOOKUP($D$39,DL!$AE$2:$AG$16,3)*$G$39,0)+IFERROR(VLOOKUP($D$40,DL!$AE$2:$AG$16,3)*$G$40,0)+IFERROR(VLOOKUP($D$41,DL!$AE$2:$AG$16,3)*$G$41,0)+IFERROR(VLOOKUP($D$42,DL!$AE$2:$AG$16,3)*$G$42,0)+IFERROR(VLOOKUP($D$43,DL!$AE$2:$AG$16,3)*$G$43,0)+IFERROR(VLOOKUP($D$44,DL!$AE$2:$AG$16,3)*$G$44,0))*AV$2)

Thanks in advance