#### carefreeant

##### New Member

- Joined
- Feb 13, 2018

- Messages
- 10

Hi,

Bit of a complicated one but hopefully it makes sense.

What I am basically try to write, is a formula that achieves the following:

Could anybody assist with this please? I have tried various version of my base formula, but just cannot quite get it to achieve exactly what I am after.

Bit of a complicated one but hopefully it makes sense.

- To the left of my worksheet I have a list of items sold, and the price charged
- To the right of my sheet I have a price list. This shows the item, the start date of the price, and then the end date of the price

What I am basically try to write, is a formula that achieves the following:

- If the product code in cell B2
- Matches the product code in X2
- AND
- The date in A2
- Is greater than the date in Y2
- AND
- The Date in A2
- Is less than the date in Z2
- Then pull through the price in AA2

Could anybody assist with this please? I have tried various version of my base formula, but just cannot quite get it to achieve exactly what I am after.

Last edited: