Hello
Could someone please give me a shorter formula which would function the same as...
=VLOOKUP($B4,'1'!$B$3:$AZ$1000,3,0)
+VLOOKUP($B4,'2'!$B$3:$AZ$1000,3,0)
+VLOOKUP($B4,'3'!$B$3:$AZ$1000,3,0)
+VLOOKUP($B4,'4'!$B$3:$AZ$1000,3,0)
+VLOOKUP($B4,'5'!$B$3:$AZ$1000,3,0)
(and so on - 113 worksheets)
Thanks for your time...
Bookmarks