syncing data between two sheets
I have two sheets which we want to use for material tracking. The one sheet is based on what comes in and is traced back to a purchase order. The second sheet is what is actually used. I would like to be able to take the actually used total and match it to the same item on the other sheet so that we know if we have over used or if we have over ordered material. Not to sure how to do this, I would assume I use some kind of VLookup, but really don't know.
thanks for the help.
Glastech Glazing Contractors Ltd
Help Article Resources
Check out the Formula Handbook template!