I have an inventory sheet that we put together. It lists the equipment down the left(multiple equipment each with a unique name ID)column A. The parts(all with unique ID's) is listed across the top in row 1. If the part belongs on the equipment we marked the intersecting cell with a 1. There can be multiple parts per piece of equipment. I am trying to do a vlookup for the equipment and give a list of the parts available. The lookup list is in a cell with a dropdown box containing all the equipment.



What is the easiest way to go about this. This is what I have done so far. I made a cell that got the MAX from the row.(which of course is 1) then I did a COUNTIF it was = to 1 to get the number of parts avialable. Then I made this to solve and get the parts in that row =IF(ROWS(N$8:N8)>$M$8,"",INDEX($B$1:$K$1,SMALL(IF( $B$3:$K$3=$L$8,COLUMN($B$3:$K$3)-COLUMN($B$3)+1,ROWS(N$8:N8))))

This formula works for one row but I can't figure out how to get the loolup equipment and tie that row in.

I did figure out how to use the lookup and tie the MAX and COUNTIF equations. It is
=MAX(INDEX(table2[[Part 1]:[Part 10]],MATCH($N$4,$A$2:$A$11,0),0))

I haven't worked much in excel but have been taking a self educating crash course for the last two weeks. I believe I have all the parts just not putting it in the right order or missing a minor part to get the last part to work.

Thanks,Matt