Bob, can I get your email?

"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.