Hello eveyone,
Im looking for asssitance on calculating a bucket level and total buckets, based on a comparison to another sheet ( Red culms)
In order to emphesize here is an example;
Sheet A ( Spend)
a.JPG
Sheet B ( Agreements):
b.JPG
Im looking for a way to calculate in the spend Sheet the buckets that appear in the Agreements Sheet. Somehow it's a Vlookup within a Vlookup but i cannot figure out how to properly design the formula so it will be based on the Item ID, and then calculate how many buckets does this crossed Item & Vendor include in the Agreement sheet, and on what bucket does it fall on ( per line).
I would appreciate any assistance on the matter,
Thanks in advance,
Asaf.
Bookmarks