Jagat Pavasia
Active Member
- Joined
- Mar 9, 2015
- Messages
- 397
- Office Version
- 2021
- Platform
- Windows
dear sir,
I have long formula below :
=IFERROR(VLOOKUP(A6,'1'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'2'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'3'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'4'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'5'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'6'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'7'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'8'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'9'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'10'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'11'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'12'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'13'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'14'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'15'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'16'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'17'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'18'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'19'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'20'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'21'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'22'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'23'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'24'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'25'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'26'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'27'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'28'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'29'!$A$6:$E$36,5,0),0)
+IFERROR(VLOOKUP(A6,'30'!$A$6:$E$36,5,0),0)
please help
I have long formula below :
=IFERROR(VLOOKUP(A6,'1'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'2'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'3'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'4'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'5'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'6'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'7'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'8'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'9'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'10'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'11'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'12'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'13'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'14'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'15'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'16'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'17'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'18'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'19'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'20'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'21'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'22'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'23'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'24'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'25'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'26'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'27'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'28'!$A$6:$E$36,5,0),0)+IFERROR(VLOOKUP(A6,'29'!$A$6:$E$36,5,0),0)
+IFERROR(VLOOKUP(A6,'30'!$A$6:$E$36,5,0),0)
please help