ExcelBanter - Auto Filling

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Auto Filling (https://www.excelbanter.com/excel-worksheet-functions/141513-auto-filling.html)

ckane

Auto Filling

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!!

Teethless mama

Auto Filling

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!!

All times are GMT +1. The time now is 10:31 AM.