Forum Discussion
Solved
Fetch a varying number of records based on criteria, and create table
I would like a sheet where the user fills in a supplier, let's say in C3. Based on this input, a column of products is fetched from a table in another sheet (Suppliers + Products). The number of pro...
If you have Excel in Microsoft 365, you can use the FILTER function.
The attached version contains an array formula that will work in all versions of Excel.
If you have Excel in Microsoft 365, you can use the FILTER function.
The attached version contains an array formula that will work in all versions of Excel.
OK, thank you!