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.