Date Range in Lookups?? Match based on range??

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    I have a workbook, with two worksheets.


    One worksheet (Called "Contract") is 155,000 lines.


    It has part numbers (often duplicated) a contract price, and a date the price went into effect.


    It shows as example, Product 1 started at one dollar January one, and went up one dollar every first of the month, so each part has entries on the first of the month for the new price (dates are actually random)


    The other worksheet (called sales) is about 400 lines long, and has an invoice, a price charged, and an invoice date



    I want to import the contract price into the sales worksheet based on the day of the invoice.


    This is to show we charged equal to or less than the contract price in effect for the particulars invoice date.


    Any possible suggestions?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login