Trying to get the proper function to make this sheet work.
From the bottom example, you select your parts from the drop down lists.
Where result is, it should return the item(s) in the top example that have the correct x's in it.
In every case it takes 2-4 parts to make an item. If you had PART1 and PART3 it should return "item2". If you had PART1 and PART2 it should return nothing.
Im hoping for a tip or two if possible - and i hope im not in the wrong forum.
thanks!
FRUIT PART1 PART2 PART3 PART4
1 item1 x x
2 item2 x x
3 item3 x x x
4 item4 x x
5 item5 x x x x
----------------------------------------------------------------------------------
NAME PART PART PART ITEM(s) CAN MAKE
1 1111 list list list result
2 2222 list list list result
3 3333 list list list result
end
Bookmarks