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 ...

excel

Excel for web

Excel on Mac

Formulas and Functions

office 365

Lorenzo
Oct 20, 2023
formulasbrokemybrain

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

Lorenzo

Silver Contributor

Oct 20, 2023

formulasbrokemybrain

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

formulasbrokemybrain
Copper Contributor
Oct 20, 2023
Thank you! Lorenzo

I knew there had to be an easier way, that works perfectly!

Thanks again
- Lorenzo
  Silver Contributor
  Oct 20, 2023
  You're welcome & Thanks for providing feedback

Forum Discussion

How to auto-populate all values in a row based off a value in an array using it's corresponding row

Resources