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($A 1,$B:$B,0)))
Copy G1 across to J1, fill down as far as required. Celebrate it, hit the
YES below
--
Max
Singapore
---
"ILunacy" wrote:
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