Formula with two variables

[McTam]

I have a Workbook that has information generated from a database. Into this I need to enter a stock value that changes weekly. Is there a way I can enter a formula that will look at a specific date and the part number? The information changes on a 15 week cycle so the 'Data' from the cell sheet one goes into the 'Data' cell in sheet 2. The column in sheet 2 would move to hidden every week. I hope this is clear enough? I didn't know if I could use a double 'IF' or can I use a 'SUMIF' with two criteria? If someone could help I would be grateful.


Sheet 2

Part No 390.00.12V 16-May 23-May
Receipts 'Data'
Issues 191 60
Balance 600 409
Value #N/A #N/A


Sheet 1
16-May 23-May
Part No: 390.00.12V 'Data'

 

[Robert Mika]

What do you mean by "he 'Data' from the cell sheet one goes into the 'Data' cell in sheet 2"
Do you move the data manualy?

You are saing that you want to look at specific data.
What would you like to retrive?
SUMIF can have only one criteria.
SUMIFS for Excel 0 and 10 can have more tahn one

INDEX/MATCH maybe helpful.Mhere your MATCH criteria can look like A2&B" but you need to gove more details of what you are trying to accomplish.

 

[McTam]

Where I have indicated 'Data' that is the cell in sheet one that needs to be recorded in sheet two. Unfortunately when I uploaded the question the cells moved across. I have tried to upload using an HTML maker but I can't find my AddIns folder because I have a roaming profile. I will try to upload again so the information is formatted properly,

thanks Alex

 

[McTam]

Sheet 1
Excel 2007
B C D E F G H
4 16-May 23-May 30-May 06-Jun 13-Jun 20-Jun
5 390.00.12V
6 390.00.LB
7 390.00.LB.PC
8 391.00.LB
Sheet 2 A B C D
1 390.00.12V Stock Arrears 16-May 23-May
2 Receipts [1] [1]
3 Issues 191 60 80
4 Balance 600 409 349 269
5 Value £2,925 £1,994 £1,702 £1,312
[1]
These cells must equal the serial number and date from the other sheet. There is a 15 week cycle and the figures will move across the sheet per week


Hope this helps in some way?

Alex