Hi FIF001,

Welcome to the forum.

I believe this question can't be handled with formulas only and it should be in Excel programming section unless you have those " certain names" in another workbook as well and then you can fetch their respective rows using some nice array combination of Index/ match . thanks.

If sounds interesting, suggest you to upload a small sample workbook.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>