Looking up data within a collumn

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.

Originally Posted by pinmaster

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.