Need help displaying duplicates with XLOOKUP pulling from form data

[billc13]

Hoping an excel wizard can help me with an issue..

I'm pulling data from a form sheet into a dashboard using XLOOKUP. I want to pull all of the accompanying data for the criteria "Industry" from the form sheet into the dashboard. The issue is I have a ton of duplicates since each "Industry" (i.e. Apparel) has 8 columns of data that I want pulled and all of that unique data displayed.

I've been using: =XLOOKUP(Dashboard!$F$6,Form1!$F:$F,Form1!$F:$N, ,0,1)

^However, this only pulls the first instance of the data in the form and not all of the duplicates.

I created a separate data sheet and unique ids but I can't seem to figure out the COUNTIF formula with XLOOKUP (if that's even the way to go).

Please help!

 

[Fluff]

Hi & welcome to MrExcel.
How about using filter like

=FILTER(Form1!$F:$N,Form1!$F:$F=F6)

 

[billc13]

Hi & welcome to MrExcel.
How about using filter like

=FILTER(Form1!$F:$N,Form1!$F:$F=F6)

Lifesaver! Guess I was overcomplicating it! haha

Worked like a charm. Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.