Forum Discussion
Automated Spreadsheet
Hi people I need some help! I need to have a spreadsheet that has a drop down list in A1 so when an item is selected it will auto populate B1 with the corresponding part number and also in C1 t...
Let's say you have a list on a sheet named Parts, with unique item names in column A, part numbers in column B and cost in column C, in rows 2 to 60 (headers in row 1).
On the sheet where you want the drop-down. select A1 (or a range in column A starting in A1).
On the Data tab of the ribbon, click Data Validation.
Select List from the Allow drop-down.
In the Source box, enter ='Parts'!$A$2:$A$60
Click OK.
In B1, enter the formula
=XLOOKUP(A1, 'Parts'!$A$2:$A$60, 'Parts'!$B$2:$C$60, "")
Fill down if required.
