How to copy row data matching specific column criteria

jazmarc You may want to use a pivot table for this and filter by the names you are interested in.  You could even add a slicer to easily select those names.

Alternatively, if you have the up to date Excel with dynamic arrays you should have a function called FILTER() which can make this process relatively easier if you have something against pivot tables.  Basically you can use:

=FILTER(A:A,ISNUMBER(MATCH($AO:$AO,$CC:$CC)))

where I have the names listed in column CC (you could change that to a different column, different sheet, or defined name) 

and then copy that right for however many columns you need.

jazmarc 

Since you have not shares any sample data as well as expected output, therefore I've assumed the data set along with the criteria, and would like to show few method, that how could you extract record/records. 

How it works:

• Cell G10, G18 and G24 has criteria to match with related records.

Method 1:

• Extract multiple rows match the criteria in one column
• Enter this array (CSE) formula in cell F12, finish with Ctrl+Shift+Enter, and fill across.

{=IFERROR(INDEX($A$12:$D$21,SMALL(IF(COUNTIF($G$10,$C$12:$C$21),ROW($A$12:$D$21)-MIN(ROW($A$12:$D$21))+1),ROW(A1)),COLUMN(A1)),"")}

Method 2:

• Get one row match with the criteria.
• Formula in cell F21, finish with Enter, and fill Right.

=VLOOKUP($G$18,$A$12:$D$21,COLUMN(A1),FALSE)

Method 3:

• Get one row match with the criteria.
• Formula in cell F26, finish with Enter, and fill Right.
• This formula in performing REVERSE LOOKUP, since the LOOKUP value (the criteria) is not in first column.

=VLOOKUP($G$24,CHOOSE({1,2},$C$12:$C$21,A12:A21),2,0)

N.B.  Adjust cell references and criteria in formula as needed.