Allen Prince
asked on
Excel lookup - Tank Volume Puzzle - Sum the volumes in tanks based on type when the list order changes
We have storage tanks that are tracked by two main types and one group of other types.
The order of the list changes as the tanks are moved around the district.
Using vlookup on type 1 and 2 we can keep track of the high priority volumes.
How would I total the volumes in all other types into one cell ?Tank-Puzzle.xlsm
The order of the list changes as the tanks are moved around the district.
Using vlookup on type 1 and 2 we can keep track of the high priority volumes.
How would I total the volumes in all other types into one cell ?Tank-Puzzle.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Keeping it simple is the way to go!
I actually lookup the values in a remote sheet, it should work for a remote reference.