Vlookup/Database formula problems

[aly1cat]

I am trying to put together a formula which looks at a list and then
searches for a the month and then applies the data to the cells.

I have enclosed a example of what I need. Please can you help!

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=426027

 

[shternm]

You've got paste your pivot table in another location (like past
values) bec. Vlookup can't read off Pivot tables.
Then use this formula:
=VLOOKUP(B7,data,2,FALSE)

B7 is your date
data is your named copied pivot table
2 is the column within your data that you want returned.
Hopefully, this makes sense :

 

[aly1cat]

ok, what would the formula be if the data was in a database (worksheet -
Poland) and entered the figures into the worksheet, such as the example
I have now enclosed?

Thanks in advance for your help.

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=426070

 

[aly1cat]

vlookup is no good to be if I cannot use pivot tables.

What I need is a formula that can search for a month in a database and
add all corresponding figures for that month e.g if Jan 04 has 6
entry's - I would like the formula to search for a specific month then
enter the TOTAL amount in the specified cell/worksheet.

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=426125

 

[Peo Sjoblom]

=SUMPRODUCT(--(MONTH(A2:A100)=1),B2:B100)

will sum B for January in A, if there can be blanks in A while there are
values in B then you need to add

=SUMPRODUCT(--(MONTH(A2:A100)=1),--(A2:A100<>""),B2:B100)

 

[aly1cat]

Sorry a bit lost at that formula especially where I put in the sheet
name I need it to relate to.

Have you got the exact formula that I could have using my example
attached?

Sorry and thanks in advance.

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=426153

 

[shternm]

sumif formula would also work

 

[Peo Sjoblom]

If there are different January dates. For one particular date yes but if the
OP wants
sum B for all January dates it is easier than using 2 sumif
(">="&DATE(2004,01,01)-">"&DATE(2004,01,31))