Lookup a Numbered List to find contract that falls within Date From and Date To columns
I have a numbered list with different pricings with different validity time periods (Date From - Date To) in months.
E.g., Item A
#1 Price = 1000, Date From = Jan 21, Date To = Jun 21
#2 Price = 2000, Date From = Jul 21, Date To = Dec 21
I have another module with time period in months and price in rows/columns, as well as quantity to derive final P * Q.
Both the numbered list and module have the same other properties. (Item A, Location, etc.)
How would I pull the correct price for each time period?