Another question regarding matching names and adding spaces

[ILunacy]

I have a new question that goes along with this. Is there a way to expand on
the cell selection? Besides the names in Column B, I also have data in
Columns C, D, E, & F that I need to keep with the names in Column B. Thanks
Again!

 

[Luke M]

Formula has been modifed, copy down and across now as needed.

=IF(COUNTIF($B:$B,$A1)=0,"",VLOOKUP($A1,$F:$F,COLUMN(B1)))

 

[Max]

A simple index/match will deliver all to you ..
Let's say your data in cols B to E,
where col B = names to be matched with the base list in col A
cols C to E are data associated with the names in col B
Put in say, G1:
=IF(ISNA(MATCH($A1,$B:$B,0)),"",INDEX(B:B,MATCH($A1,$B:$B,0)))
Copy G1 across to J1, fill down as far as required. Celebrate it, hit the
YES below