Return a range by looking up one cell.

Tempest_Petals 

Would you happen to know a way of to accomplish this?

You need to be a bit more descriptive of what the "this" is. You've talked of needing to access a list of the names. You've talked of using the names in a formula. I can envision a dropdown (data validation) as a way to access a list. Also one of many lookup-type functions. But then you include the notion of including the names (presumably one at a time) in a formula, but you don't say what it is that the formula is supposed to do.

Talk us through the full process (describing it in English, not in "Excelese"; let us worry about the translation into Excel functions or procedures) ...  This would probably be easy if we were sitting down face-to-face, because we could go back and forth, clarifying as we go along. Instead, I'm asking you to describe pretty thoroughly what the whole process is here. It might help if you assume:

1. you're talking with a relatively intelligent person
2. that person knows nothing of gaming, game characters and what one does with them
3. that person does know Excel, but wants you to not talk Excel per se, just to talk of the information and what needs to happen to it, with it, etc.