Forum Discussion
Solved
How to auto-populate all values in a row based off a value in an array using it's corresponding row
I am looking to have rows of data appear in one sheet from a master list depending on specific criteria, I want the entire row to fill in the same way it is found in the master list on another sheet ...
in D10:
=FILTER('Weeklies (ALL)'!E$10:CS$29, 'Weeklies (ALL)'!C$10:C$29=C10, "Not found")and copy down for the next names
in D10:
=FILTER('Weeklies (ALL)'!E$10:CS$29, 'Weeklies (ALL)'!C$10:C$29=C10, "Not found")and copy down for the next names
- You're welcome & Thanks for providing feedback
