which formula should I use? PROCV or SOMASE or another..

[stazevedo]

Well, i've been trying solve a problem with mentioned formulas above.. but I can not find the value I'm looking for ..

Problem:

A b c d
03/07/2011 200 jul/07 200
05/07/2011 200 aug/07 320
29/08/2011 320 sep/07 319
12/12/2011 oct/07 400

I need the value in column B that matches the date in column A to be located in column C, are dozens of launches and the C column not always will be in ascending order. The date formats are identical those of my spreadsheet. As entradas na coluna A estão por dia e os valores devem corresponder ao mês da coluna C.

Tkz

[Glenn Kennedy]

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon

[stazevedo]

Ok, here's an example.

[Glenn Kennedy]

Is this what you needed? Most of the data aren't there, so the formula has not returned many results... Is it ALWAYS the case that the first mentioned date in column A for any month also has an entry in column B?

[stazevedo]

Actually I need formulas in column B. The data in column E should be entered in column B in accordance with the existing date in column A.
EG.
In column A the date is 07/01/2013 then by formula should be sought July 2013 in column D. The value of the column and should be reported in B. In this example would be 972.706.

Tkz again.

[Glenn Kennedy]

Ahhh. Take a look at this, then...

[stazevedo]

Thats what i call music.. tkz a lot my friend.

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.