I have posted an example at http://cjoint.com/?clpVZyNcIc

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Kylie Rose" wrote in message
...
Thank you very much for your time, it astounds me that people take the
time
out to answer others problems here, it's great.

I'm ashamed to say I don't quite understand the answer you have provided
but
will endeavour to work on it tomorrow when I have a clear head. I'm sure
it
makes perfect sense.
Kind Regards
Kylie

"Bob Phillips" wrote:

Kylie,

Assuming that the headings are in A1:D1, create a DV box, and with a
type of
list, add this formula


=OFFSET(A1:D1,1,MATCH(G1,OFFSET(A1:D1,0,0,1,COLUMN S(A1:D1)),0)-1,COUNTA(OFFS
ET(A1:D1,1,MATCH(G1,OFFSET(A1:D1,0,0,1,COLUMNS(A1: D1)),0)-1,1000,1)),1)

This assumes the selected item is in G1

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Kylie Rose" wrote in message
...
I am trying to use excel for a database and would like to create a
drop
down
box for the contact numbers of individuals, I would like everytime I
select
an alternative heading (four of them) that the data then coincides to
all
individuals in the database, ie, select fax numbers from a drop down
box
also
containing home, work and mobile numbers and then have all the
individuals
fax numbers appear in that column. Is this possible??

Thanks to anyone taking the time to answer this.
Kylie :)