Hi All
Facing a issue I would like to solve. I have to drop down menus
First drop down is list of suppliers type (A,B,C,D etc)
Second is criticality (Critical, major and Minor)
I have created a Matrix which combining supplier type with criticality and this gives number of visits per year.
I would now like to use this matrix on all our 900 suppliers
My question is how can I set-up a formula to give me visit frequency ( based on the two drop down menus of supplier type and criticality
Facing a issue I would like to solve. I have to drop down menus
First drop down is list of suppliers type (A,B,C,D etc)
Second is criticality (Critical, major and Minor)
I have created a Matrix which combining supplier type with criticality and this gives number of visits per year.
I would now like to use this matrix on all our 900 suppliers
My question is how can I set-up a formula to give me visit frequency ( based on the two drop down menus of supplier type and criticality