Hi,
I create a daily sale report in excel for merchants of the product to bill them as per sale/lead I generate on daily basis. My merchants send me price changes of the product very frequently almost twice-thrice in a week with daily amount limit I can bill them maximum per product. Based on those changes I have to create a report for them to bill monthly.
I paste their changes request in different sheet date wise as given in attach file from where I take reference for product rate and daily spent limit. If i don't receive a change request on a particular date then I have to consider previous earliest date changes and use in my reporting. I am looking for a formula which can pull Rate and Limit/day from my change request sheet automatically by date and product id by delivery type.
Any help will be appreciable.
Bookmarks