I thought I'd give your code another bash and hey presto - it worked! Thanks.

"slavenp" wrote:

Thanks for the post, but it doesn't help. What I'm trying to do is when you
select a name in column A, the address shows in column B and phone number in
column C. I have set up the drop down menu to allow for a name to be
selected in A, but don't know how to get columns B and C to fill at the same
time. I have all the data for column A sitting in rows A:62-A123, column B
data is in rows B:62-B123 and column C data is also rows C:62-C123. Does
that give a bit more info?

"Toppers" wrote:

See VLOOKUP in HELP.

Assuming your additional information is in Sheet2 columns A to C:

in B2:

=VLOOKUP(A2,Sheet2!A:C,2,0)

will return value from column B in sheet2 corresponding to A2 value

in C2:

=VLOOKUP(A2,Sheet2!A:C,3,0)

will return value from column C in sheet2 corresponding to A2 value

HTH




"slavenp" wrote:

I would like to select from a drop down menu in colum A and after selecting
the required text, colums B and C get populated with additional information.