I'd like to set up sheet showing data from a number of contracts and have
formulas on worksheets tracking individual items refer to the "contracts"
worksheet. I'd like to have the "contracts" worksheet containing the
following headings:
Contract Item
StartDate
EndDate
Unit Price
I'd like to have Excel pick up the proper price when given a date and the
contract item. For example, on the sheet to track item7, I would have columns
with invoice date, units purchased, and unit price. I'd like a formula in
the unit price column to pick it out of the contracts worksheet based on the
invoice date being in the term of the contract and the contract item would be
item7 in this case.
Any given date will have multiple contracts (nine, actually). But only one
for each item.
Any thoughts?
Thank you.
EQC