I'm trying to create a worksheet that populates cells corresponding to 2 drop down lists.
The list is a material list (it will contain many more rows that what are currently in there).
I'd like to be able to select the material type from a list in the 1st column and the size of the material in the second column (which I've created using data validation) but I'd like the next 2 cells to be populated with the information corresponding to that specific type of material and size.
I've named the data range and created the drop down lists but I don't know how to automatically populate the remaining 2 cells.
Also is there a quicker way to update the Data Validation formula in column 2 (Size) (=Indirect(A24))
than doing it manually for each cell. Like a Select the whole 2nd column and update all cells in it at once so the formula (=Indirect(A24)) will change the cell number to A25 in row 25 and A26 to row 26?
Sample worksheet attached.
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.