Looking up data within a collumn

[Demitre]

Hi,

I am trying to look up data within a column by using a unique data
within that same column.

For Example, the data will be listed as shown:
Column A
Name1
Phone1
Address1
Name2
Phone2
Address2

Now I want to be able to just type a name in Collumn D, and have the
phone number print out in Column C, and the address in Collumn E. Is
there a way to do that? Column A won't be large, under 200, so load
time is not a big concern.

 

[pinmaster]

Hi, how about:

=OFFSET(INDEX($A:$A,MATCH($D1,$A:$A)),COLUMN(A:A),0)
copied across

HTH
J

 

[pinmaster]

Oops...you said you wanted phone # in C and address in E.

in C
=OFFSET(INDEX($A:$A,MATCH($D1,$A:$A)),1,0)

in E
=OFFSET(INDEX($A:$A,MATCH($D1,$A:$A)),2,0)

Regards!
JG

 

[Demitre]

Hi, try this:

in C
=OFFSET(INDEX($A1:$A100,MATCH($D1,$A1:$A100,0)),1,0)

in E
=OFFSET(INDEX($A1:$A100,MATCH($D1,$A1:$A100,0)),2,0)

Regards!
JG

Hey, it seems to work great!, thanks alot.