Lookup 2 different dates and return a horizontal lookup

You need to convert your multiple tables to a single database. From this (for two items in your first table)

Capture 1.JPG

to this:

Capture 2.JPG


You can do that with VBA or by controlling the creation of the RAW sheet - but the multiple tables, headers, etc. that you currently have make it impossible to extract information in a meaningful way without that transformation.

In C10, use

=SUMIFS(Raw!$D:$D,Raw!$A:$A,$B10,Raw!$B:$B,$A$4,Raw!$C:$C,C$6)

and copy down and across to create your table.

I lost this thread. I was a bit bored earlier today and played around with the old format, just for fun...

The dates are a mess. Some are dates, some are not. I have fixed them down to 19th April on BOTH sheets. You can do the rest.

So, it can be done with a formula. But unless it's a huge pain to get them all in a single range, Bernie's solution is to be preferred.

The monster formula in C10, copied across and down is:

Formula:

Please Login or Register  to view this content.