I do appreciate your help but I must tell you I have no idea what I am doing
so you information is Greek to me. This is what I have and if you could
please help me through it I would greatly appreciate it.

Sheet 1 I inserted a "combo box" which I linked to sheet 2 which had the
names of the builders (this part is fine, when I select the pull down I see
each of the builders.) Now where I am getting confused is I have the
information about each builder on sheet 3 but I can seem to make it work so
when I pick the builder from the pull down the information from sheet 3
shows up on sheet 1.

If that makes any sense I would be greatly in debt to you for some help.



"Bob Phillips" wrote in message
...
Joe,

assuming that the listbox has a linked cell of say A1, use VLOOKUP
something
like this

=VLOOKUP,A1,Sheet2!$A$1:$H$100,2,FALSE)

changing the ranges to suit, and the ordinal number for each field
required.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe" wrote in message
...
I have no idea what I am doing and I could use some help please. I have
a
pull down menu on sheet 1 and it contains a list of builders who we work
with. What I need is when I choose the builder from the pull down menu I
would like to have all of the specific information associated with that
builder (which is contained on a different sheet) to appear on that
first
sheet in some kind of "box" or group of cells. We are using Office 2000
on
Windows 2000

Thanks in advance for any help.