VLOOKUP and SUMIF???

[reneedahl]

Hi Everyone,

I need help with a Vlookup and Sumif (i think).

What i need to do is lookup the company name from the list and add them into the table if the dates are feb, march, april etc. My problem is, that there are different dates for each month so thats where im getting stuck.

I have attached the sample and i need the information to come from the source table to the right of the table. Can anyone help me?

ReneeBook6.xlsx

[Mike Chester]

In the table K4 to R19, where can I find the dates? Is it the one in the O column?

[reneedahl]

Yes it is the dates in O. So the top table needs to look up the dates in Column O and use the figures in column P which there are in the original spreadsheet. Then the second table looks up the dates in column Q and adds the figures from column R. If that makes sense?