Take a look a VLOOKUP function in Excel Help menu

"ckane" wrote:

I have created a table with multiple columns. In one column I have created a
drop down menu of about 2100 items. When this item is selected I would like
3 other columns to automatically fill with the corresponding data. Thank you
for your help!!