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.


--
Demitre
------------------------------------------------------------------------
Demitre's Profile: http://www.excelforum.com/member.php...o&userid=29720
View this thread: http://www.excelforum.com/showthread...hreadid=495060

Looking up data within a collumn
 

Hi, how about:

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

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495060

Looking up data within a collumn
 

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


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495060

Looking up data within a collumn
 

pinmaster Wrote:
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.


--
Demitre
------------------------------------------------------------------------
Demitre's Profile: http://www.excelforum.com/member.php...o&userid=29720
View this thread: http://www.excelforum.com/showthread...hreadid=495060