T
tedc
have a dog show registration form created in Excel 97
I have a database named ShowTable in which I have columns for Club,
Secretary, Address, Town/City, Postcode (zip)
On the main form, I have a combo box which is linked to Club column and
this places the club name in a separate cell (say c23)
What I would like is to have the Club name linked with the correct
Secretary name (to appear in say C24)
And the rest of the information to do follow the same procedure (say
(C25 onward)
I have tried VLOOKUP but this only returns me one set of names
(Secretary, Addresses, etc) and does not link with the club name.
Is there a solution?
Ted Cullen
Jack Russell Terrier shower and racer
Attachment filename: excel.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=391056
I have a database named ShowTable in which I have columns for Club,
Secretary, Address, Town/City, Postcode (zip)
On the main form, I have a combo box which is linked to Club column and
this places the club name in a separate cell (say c23)
What I would like is to have the Club name linked with the correct
Secretary name (to appear in say C24)
And the rest of the information to do follow the same procedure (say
(C25 onward)
I have tried VLOOKUP but this only returns me one set of names
(Secretary, Addresses, etc) and does not link with the club name.
Is there a solution?
Ted Cullen
Jack Russell Terrier shower and racer
Attachment filename: excel.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=391056