Hi,

Please refer the table below

Priority Excellent Average Needs Improvement Poor
High 8 6 4 2
Medium 6 4 3 2
Low 5 4 3 2

I've maintained another excel sheet which has 3 colums by names Results,
Priority and Scores.
When i enter Excellent and Medium in respective Colums Results and Priority,
it should fetch the Scores from the above table as 6.

Please help