Hello,
I'm struggling with finding solution for my problem.
In file attached there are 3 tables. In TABLE A I would like to return sum based on my criteria where sum range and criteria range would contain formulas A and B (shown in TABLE B). I'm not sure whether these formulas can work in similar manner but that's how I'm trying to explain what they should do.
Formula A should calculate amount depending on Code 2 (either Amount_end picked up or amount_end - amount_start). Then Formula C would look in separate TABLE C and return Code 1 equivalent for Code 2 as in TABLE A my array is with Code 1.
It would be easy if I actually executed formulas A and B in TABLE 2 and then used returned values in formula C, but I cannot do that as I have tables in separate sheets and table 2/3 cannot be modified with additional calculations (or it would be inefficient as there are too many of them)
I would appreciate any help which would guide me to write proper formula or perhaps this is possible only with VBA code?
Thanks
scrin
P.S. attached both image and excel file
Bookmarks