Offset with criteria query

[SimonTemplar]

Hi,
This is my first post, so please excuse any etiquette failings.
I have a spreadsheet that uses the value in cell (A1) and (P1) (on summary sheet) and then via some x-lookup's populates cells (B:F) with various values (amount, inv number, date etc.) which works fine.

However, if there is more than one result I need to run the same search ignoring the above result and return values across cells (G:J). And again, if there is a third result, I need to do it again and return values across cells (K:N) and so on. To do this I'm using OFFSET to move the search down 1 row, but unfortunately although this brings me the data ok, it's not taking in to account the condition in cell (P2).

For example when searching PO12345 in Jun, I'm getting 5 results, but two of them is actually dated July and the 5th result is showing a date of 00/01/1900.

Can anyone suggest how I can add a condition that states if the period (P2) isn't matched, then the value is zero if all fields?

I also need to add a billed in period, billed to date and balance available, but think I can do this via IF and AND?


Any suggestions appreciated.
Thanks

[AliGW]

Welcome to the forum.

P2 where? The data in the workbook does not seem to match what you are describing.

However, in principle:

=IF(formula<>P2,"",formula)

[avk]

I preferably choose simple pivot table.
I have do some remove rows & make pivot table.
Plz look pivot sheet.

[SimonTemplar]

HI Ali,
So sorry, I added some columns for the additional results to pull through and forgot to update in my post that the cell is X2 (i.e. this is the date toggle cell which when selected affects part of the criteria for the formulas in columns C, G, K, O AND S (e.g. the invoice number results)
Apologies for the confusion

[AliGW]

If you still need help, please post updated instructions that match the sample workbook. If not, please mark the thread as solved.

[avk]

Are you refering my #3 post.