•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Returning multiple matches per ID (auto-fill when dragged down?)
Our take
If you're looking to return multiple matches per ID efficiently, you've come to the right place. The challenge of automating this process while dragging down your upstream ID column can be daunting, especially when relying on traditional functions like FILTER, which may not adapt well to expanding data. Fortunately, there are formulas that can streamline your workflow. By implementing the right approach, you can ensure that all corresponding values are pulled seamlessly, regardless of whether they share the same code or not.
Hi there! I have multiple assigned IDs for a single code so I need to return all matching values, not just one. I also want this to be kind of automated (?) when I drag down the upstream ID column, it can pull all corresponding values, even if they share or don't share the same code
I tried using FILTER, but it only spills results in one place and doesn’t carry over properly when dragged down for other rows. I don’t want to adjust ranges every time manually since my data might get longer.
Is there a way to make a formula that:
- works when dragged down,
- returns multiple matches per ID,
- and still updates properly even if the data goes beyond the current rows?
Left Side = source workbook; Right Side = destinatioon workbook
Thank you so much in advance!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#rows.com#real-time data collaboration#no-code spreadsheet solutions#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#AI formula generation techniques#automated anomaly detection#Excel compatibility#real-time collaboration#formula generator#Excel alternatives