Hello

currently I have an index/match formula pulling the % from a table. However, I want to build a range into this formula and despite a few attempts - I can't quite manage it..

1>1.99 2>2.99 3>4 (scores)
Employee 0% 1% 3%
Employee1 0% 1% 5%
Employee2 0% 2% 8%
Employee3 0% 2.50% 1%
Employee4 0% 1.50% 5%

For example, Employee2 achieved a score of 2.79, from the table above this would equate to the percentage value of 2%. I would like to write a formula which will pull the corresponding % value from the table based on score within the range.
At the moment I am using an index/match but it will only pick up an absolute values, not the range

I can't figure out how to tackle it..