I want to point to a name by its index number:
=NameSheet!D[VariableOfRowContainingNameIWant]

The kind of formula I want to use is like this, only instead of the "12" I
want to use a variable, like G3:
=CONCATENATE(People!C12," ",IF(LEN(People!D12)0,CONCATENATE(People!D12, "
")),People!E12)

I am trying to display a person's name using their number.

I'd like to avoid going to Visual Basic.

John