Another question regarding matching names and adding spaces

  • Thread starter Thread starter ILunacy
  • Start date Start date
I

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!
 
Formula has been modifed, copy down and across now as needed.

=IF(COUNTIF($B:$B,$A1)=0,"",VLOOKUP($A1,$F:$F,COLUMN(B1)))
 
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
 
Back
Top