Looking at the formula below you see a total of 3 arguments
=(VLOOKUP(G33,PivTbl_LookUp!A:B,2,FALSE)+(VLOOKUP(H33,PivTbl_LookUp!A:B,2,FALSE)+VLOOKUP(I33,PivTbl_LookUp!A:B,2,FALSE)))
I am hoping there is a way of simplifying it (shortening it) because I will have a total of 18 arguments (it will count column G through X)
My example includes only G through I)
=(VLOOKUP(G33,PivTbl_LookUp!A:B,2,FALSE)+(VLOOKUP(H33,PivTbl_LookUp!A:B,2,FALSE)+VLOOKUP(I33,PivTbl_LookUp!A:B,2,FALSE)))
I am hoping there is a way of simplifying it (shortening it) because I will have a total of 18 arguments (it will count column G through X)
My example includes only G through I)