Sum cell across Worksheets - Using VLookup

[barosebud]

Hi,

I have created a April 2018 workbook for a production project; each tab representing a day of the month; in this case, Mon 2-Mon 30. On each day I have an identical layout/formulas.
I used drop down lists so the operator can select various programs they are working on and actual pieces completed.

In the workbook I also have, a separate, Master Tally Sheet that my boss wants to keep a running total of the various programs run through out the month and their qty.
I can use a VLookup formula to return the correct qty, but cannot figure out how to do this for the entire monthly range and not just one day. See my working formula below

ex:=IFERROR(VLOOKUP('MASTER TALLY SHEET'!C4,'MON 2'!$G$5:$J$13,4,FALSE),0)

How can I set this formula up to return the correct qty, but as a running total for the entire month ---"Mon 2:Mon 30'?


Thank You!

 

[alansidman]

perhaps you could do this with the Consolidate Function

Look at this link http://www.excel-easy.com/examples/consolidate.html

 

[barosebud]

Thanks Alan!

I am looking into that now - sure wish Vlookup would query multiple worksheets! Hopefully Consolidate will solve my issues.
Thanks Again! Beth

 

[barosebud]

Unfortunately consolidate does not work for my issue - any other ideas would be greatly appreciated. - Thanks!

 

[alansidman]

difficult to respond without seeing sample workbook. Need to understand your layouts and how data will come together/summarized.