=vlookup(dropdown_cell,other_sheet!A:B,2,0)

"tbax6" wrote:

Have created a worksheet with a drop down box containing data from seperate
worksheet's column A and need to show the matching data in column B.
Suggestions?