Need help displaying duplicates with XLOOKUP pulling from form data

billc13

New Member
Joined
Jan 20, 2023
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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!
 

Attachments

  • dashboard view.PNG
    dashboard view.PNG
    47.1 KB · Views: 27
  • data sheet view.PNG
    data sheet view.PNG
    34 KB · Views: 25
  • form view.PNG
    form view.PNG
    39.6 KB · Views: 25

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Hi & welcome to MrExcel.
How about using filter like
Excel Formula:
=FILTER(Form1!$F:$N,Form1!$F:$F=F6)
 
Upvote 0
Hi & welcome to MrExcel.
How about using filter like
Excel Formula:
=FILTER(Form1!$F:$N,Form1!$F:$F=F6)
Lifesaver! Guess I was overcomplicating it! haha

Worked like a charm. Thank you very much
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top