Hi,
I have a spreadsheet in which I would like to select some values from a drop down list, and have the remainder of the values in that row populate automatically. I've made a couple of screenshots to illustrate.
Tool list.jpg
dESCRIPTION.jpg
I have the tool list (upper most screenshot), which will have all the tools I need to use, and I would like to be able to select the tool (in the lower screenshot), followed by the OD, and then have the remainder populate as per the tool list.
Please note, the 2 x "tool" in the list are the same tool, but they are different sizes. I would like to be able to select tool (and ideally only have one in the dropdown list), and have the relevant OD's appear in the dropdown list, then populate the remainder of the cells?
I would imagine I will have to use VLOOKUP for this, but some guidance would be good?
Thanks,
Stewart
Bookmarks