# drop down list to fill other cells in row

I just added drop down lists on my inventory spreadsheet.

I'm using the drop downs for the 'item type' column (column A), with the source being an item list on a different sheet within the spreadsheet.

column B is for the dimensions, column C for weight and a few more detail columns. is there a way to automatically have the other fields filled in with the details once I select the item type from the list?

thank you

Not quite clear what is required - do you want

drop down listsfor column B, column C, ... to be filled depending on the selection in column A--or --valuesto be filled into column B, column C, ...depending on the selection in column A (since they are unumbigous if value in column A is defined). The solution to this would be a simple`VLOOKUP`

in what you calleda different sheet within the spreadsheetYes 2, trying vlookup worked exceptionally! very nice!

The only issue I have now is when my drop down list is selected and I insert a row below, the inserted row has the drop down list which is great, but the vlookup formula does not.. I copied the cell with the formula and did a special paste of formula only, doing so the formula's criteria changes to the next cell down but so does the array range, here's the formula, 1) is the correct formula, 2) is what is formula pasted, you can see the array has changed...

1) =VLOOKUP(A2,$'Inventory'.A2:M41,2,0)

2) =VLOOKUP(A3,$'Inventory'.A3:M42,2,0)

is any way to have the formula array stay the same when pasting or any other way to insert rows below to have the formula added without array change?

Thank you