Using a variable to point to a location

J

John

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
 
D

Don Guillett

where the name in g3 matches col d on the sheets tab. Or modify for a number
instead.

=INDEX(people!d:d,MATCH(g3,people!d:d,0))& "
"&INDEX(people!e:e,MATCH(g3,people!d:d,0))
 
J

John

That's nice, Don. Thanks a lot.

John


Don Guillett said:
where the name in g3 matches col d on the sheets tab. Or modify for a
number instead.

=INDEX(people!d:d,MATCH(g3,people!d:d,0))& "
"&INDEX(people!e:e,MATCH(g3,people!d:d,0))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
John said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top