Help with multiple lookup

[iburnbud]

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!

Please Login or Register  to view this content.

end

[TJKarakowski]

I don't really understand the questions. If you email me your sheet or page, I'll take a look at it.

-TJ

[email protected]

[iburnbud]

I don't really understand the questions. If you email me your sheet or page, I'll take a look at it.

-TJ

[email protected]

maybe this is better - above example where it says list-- you choose from the parts and it gives the answer in result.

Please Login or Register  to view this content.