Using XLOOKUP to return multiple (variable) rows

Hi

We have a spreadsheet which records many data on separate tabs. The workbook is typically used for a year, so there are a few thousand rows overall. We extract some of these data onto a daily printout of salient information. The current formula finds the date specified in the list of data from a different tab, and returns as many entries as there are for that date. I find the current formula (based on old Excel) difficult to troubleshoot and correct when there is an error. I can easily create an XLOOKUP formula to pick up the data from the first row we need, but I'm struggling to see how to get the other rows to display.

Tab name of the other tab is "CIP". On the Daily Report tab, the date of the report required is in cell N2.

Old formula:

=IF(ISERROR(INDEX(CIP!$C$6:$P$63847,SMALL(IF($N$2=CIP!$M$6:$M$63849,ROW(CIP!$C$6:$P$63847)-MIN(ROW(CIP!$C$6:$P$63847))+1,""),ROW(CIP!A1)),COLUMN(CIP!A1))),"",INDEX(CIP!$C$6:$P$63847,SMALL(IF($N$2=CIP!$M$6:$M$63849,ROW(CIP!$C$6:$P$63847)-MIN(ROW(CIP!$C$6:$P$63847))+1,""),ROW(CIP!A1)),COLUMN(CIP!A1)))

New XLOOKUP formula which collects the relevant info - only for the first row! - and spills the other columns:
=XLOOKUP($N$2,CIP!$M$6:$M$63847,CIP!$C$6:$N$63847,"",0,1)

From reading help files, it seems I can use an array formula to look up an nth value, but each day there will be a different number of entries (rows). If there are none, the ISERROR returns a result of "", and I'd like to update this to IFERROR at the same time.

Unfortunately I'm not very good at structuring complex formulas and I end up getting tangled. Can anyone give me a formula for this? First screenshot is the daily report showing the CIP information captured on the report using the old formula. Second screenshot shows the data from CIP tab with 10 entries on 1st Dec; 12 entries for 2nd Dec; 0 entries for 3rd Dec...

Screenshot 2022-12-08 170447.jpg
Screenshot 2022-12-08 170806.jpg

Really? Is this the quality of service for people who have genuine queries, and who provide all relevant information, clearly identified and clearly articulated with clear pictures - that a moderator tells me off? Perhaps you should rethink your service model. The yellow banner at the top of the page doesn't say this is compulsory, it states "Fast answers need clear examples." I have provided VERY CLEAR information. What extra information would an empty spreadsheet provide you? If you are an expert in formulas, (which is, afterall why I submitted to the forum), you have all the information you need.

Very disappointed in this response.

In fact, you know what? Earlier in the year I submitted a post with a screenshot and clear description and it was answered just fine, but now your complete lack of customer service has annoyed me so much that I'm quitting the forum.

None of my recent posts have given me any answers. I've been told by a Forum Guru "Do this" when in my original post I clearly say "I've already done this and it didn't work", and he went on to tell me "It must be a SharePoint issue" when I've already clearly said it isn't a SharePoint issue because I have other workbooks saved in SharePoint where I can do this task.

I've been told by a Valued Forum Contributor that "It doesn't work because of..." and I already know it doesn't work, which is why I'm asking on the forum how to get it to work. But she didn't give me any help at all.

So, a Moderator, a Forum Guru and a Valued Forum Contributor all gave me exactly ZERO help - why should I stick around? There is a much better community at 'techcommunity.microsoft.com/t5/microsoft-excel/ct-p/Excel_Cat' where people read my post, give help, and I don't get told off from a moderator for not completing an optional step.