Look up tool

Hi,

I work for a company that mucks away large quantities of materials. Currently we track this in two ways, first on an export log which has lots of information all important to us but importantly logs every single lorry for each day. Secondly in a muckaway tracker which deals with specifically the volume of material we have removed per day and per week and also tracks the cost of moving the muck etc.

The muckaway tracker is fed from the export log, currently the export log is manually filled in on excel by the site team. And then once complete the office team will look at the export log and manually insert the total volumes removed per day and then the tracker will work out how much per week etc.

What I am after is a look up function with an if function so I can automatically total the volume mucked away depending on the date and the type of material. I have explained this better in the attached excel spreadsheet.

Cheers,

Place the below formula in D3 of Sheet1, then fill down, right, etc. to fill your table. It's working for me; let me know if you have any issues.

Formula:

Please Login or Register  to view this content.