The cell N4 is the dropdown box that has a list of equipment. Cell N8 works but only looks at the row that I set it up for. I would like to be able to reference the row by your pick of the piece of equipment from cell N4 and then populate the list with the available parts.

Is this possible?!?!

I hope this works, Matt

Inventory test sheet.xlsx