Hi,

I want to make use of a vlookup (i think thats what i need!) but not sure
how to get it working:

I have a drop down list - when user selects something from within list, the
cell next to it would be populated with information relating to this from a
lookup sheet i am using. This bit is simple, i have created the vlookup so
once something is selected it looks up in the sheet where that info is stored
and it returns back what is required in the cells next to it.

But the problem is, the vlookup appears to be limited to returning one cell
only.

If i have info displayed as:

a b
c
d

So if 'a' is selected in the drop down list then it should display b,c,d in
(which are all displayed in seperate cells in the lookup sheet), the lookup
only returns the fisrt cell - which is 'b'. how can i get it to return the
other items too? maybe something more comlex that a vlookup?

please help. thanks.