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