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