Excel Smart Price Buckets "Pivot"

Welcome to the forum!

I'm not sure I fully understand where your numbers are coming from. I think I understand the "Agreement" sheet - you want the buckets to be counted based on the number of listings for that particular item and vendor, as in the photo in your post. For the "Spend" sheet, though, your photo doesn't match the attachment. Based on the photo, it looks like you want to return the bucket number that matches the Vendor ID and Price (Should the item# match, too? It doesn't in the photos...), but the attachment does not include the price column that is included in the photo. Can you please clarify what lookups you want to occur in order to return the results in the "Spend" sheet? Additionally, are you looking for "Bucket" and "Bucket Price" as indicated in the attachment, or "Bucket" and "Total Buckets" as indicated in the photo?