Hi All,
I am new to this forum and relatively new to excel formulas so be nice. I have this matrix with rows and columns see below:
Years Experience
>20 >15 >10 >8 >5 >3 <3 (input24)
(Input23)Education PHD/Doctorate 1 1 1 2 4 4 5
Masters Degree 1 2 2 3 4 4 5
Bachelor Degree 2 3 3 3 4 5 6
Associate Degree 4 4 5 5 5 7 7
Technical Diploma/Professional Qualification 5 5 6 6 6 7 7
0/A Level/High School Diploma 7 7 7 7 7 7 7
No Formal Education 7 7 7 7 7 7 7
and a drop down list with Experience and Education, so when the user selects Education and Years Experience from the drop down list, a rating is shown that corresponds to the matrix above. (B19 and C19 are the cells with the drop down list)
Formula:
=INDEX(Data,MATCH(B19,Input24,0),MATCH(C19,Input23,0))
However, at times the formula pulls the wrong number. Please help!
Bookmarks