software

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: www.excelforum.com/member.php...oamp;userid=29720
View this thread: www.excelforum.com/showthread...hreadid=495060
Hi, how about:

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

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=495060
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: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=495060
pinmaster Wrote:
gt; Hi, try this:
gt;
gt; in C
gt; =OFFSET(INDEX($A1:$A100,MATCH($D1,$A1:$A100,0)),1, 0)
gt;
gt; in E
gt; =OFFSET(INDEX($A1:$A100,MATCH($D1,$A1:$A100,0)),2, 0)
gt;
gt; Regards!
gt; JG

Hey, it seems to work great!, thanks alot.--
Demitre
------------------------------------------------------------------------
Demitre's Profile: www.excelforum.com/member.php...oamp;userid=29720
View this thread: www.excelforum.com/showthread...hreadid=495060