I might be making this too complicated. I am trying to look up a value in a table based on two values. I have a table with 100 employees and I want to add a column with their quartile rank based on position.
Column M has everyone's position | Column has the employees
I want the formula to return the top value which represents the quartile
search table
Column M has everyone's position | Column has the employees
I want the formula to return the top value which represents the quartile
Column M (employee position) | Column K (YTD Results) | Formula results (quartile score) |
Manager | 120.00% | 4 |
Coach | 79.00% | 3 |
Employee | 180.00% | 1 |
search table
4 | 3 | 2 | 1 | |
Manager | 28.49% | 115.60% | 138.94% | 181.33% |
Coach | 55.47% | 107.20% | 140.38% | 168.74% |
Employee | 47.09% | 84.80% | 108.13% | 122.65% |