You would need a formula in first cell dragged down 9 rows (max number of items in any list)....
e.g.
=IFERROR(IF($B$1=$M$42,INDEX(INDIRECT(LOOKUP($A$1,{"27","34","06"},{"Blades 27m42","Blades 34m42","Blades 06m42"})),ROWS($A$1:$A1)),""),"")
copied down 9 rows.
Bookmarks