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 the cost of the selected Item.
thanks
Jamie
2 Replies
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.
