Need help with Nested formula IF, AND, OR to create status report

With so many variables, perhaps it is better to compile a table of them all and then you can use a VLOOKUP formula, as in the attached file.

Hope this helps.

Pete

thank you for your answer, but i dont think it will work, i need to have finaly something to react like this. Chooseing one charactristic from the drop down list in each of the 6 colomns, and than in the colomn with weighting of failure should apear depending on combinations ...low,medium,high. Each line will be for a separate product, so each combination diffrent. In my excel I put all possible combination. I got the idea from the atached excel, but here is only 2 colomns and not so many combinations.
http://home.kpn.nl/wikkepedia/templa...g_Template.xls
Is there another possibility to create this report in order to work?

ef573_Supplier complains.xls
Hi, it is not realy helping. Please check the attached sheet with how it should look like this report. Maybe using this foormulas combined is not the best idea, maybe something with vlookup, or match or other formulas. Please let me know if you encountered smth similar in your experience and how you solved.
Thank you.