Restrive a price in one table matching dates and product from another table

**brunoaragao** · 03-28-2013, 06:07 AM

Hello. I have to tables. One (ORDERS) is for registering purchase orders and the other (COSTS) is to update the weekly price.

[URL="https://www.dropbox.com/s/ytpa6juc3at9yee/sample.xls"]

I need the cells in column I from table ORDERS to calculate the cost when the following conditions are…
- The purchase order from table ORDERS is within two dates from table COSTS;
- The product in Table ORDERS matches with the product in table COSTS;
- The result (Cost) would be given by the column F in Table COSTS.
Note: These 3 conditions must happen.

I’ve been trying several solutions but none of them have worked so far.

Thank you for your help.

**Fotis1991** · 03-28-2013, 06:12 AM

Hi and welcome to the forum.

Nice pictures, but can you work on a picture? If NO, then pls upload a small sample workbook.

**brunoaragao** · 03-28-2013, 06:59 AM

Hi Fotis1991, I don't know any way of working with pictures. So I don't understand your question. If you have the solution please tell me, I am sure lots of people would be thankful for that.

I wanted to upload a sample but I can't see any option to do that, I can only see the Image upload button. It is the first time I am in this forum so, if you don't mind and show me how to do that I would appreciate.

**Fotis1991** · 03-28-2013, 07:24 AM

..I don't know any way of working with pictures.[/U][/B] So I don't understand your question.

Me too.

I can not work on a picture. I need a sample workbook.

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.