Output a matching value from my table based on several criteria

i have attached an image of an example of my dilemma. Firstly the table with headers degree, start, end and lvl is data that i have created. in the second table with the headers lean angle and slip are the data collected. What im trying to do is create a formula that firstly finds the same lean angle from the second, and match it to the first table so, identifies which row its needs. I then need it to say whether the value of slip falls within the range of the start and end value so for example the first lean angle is 0.00, so it would identify that the value of 0.00 in the first table is in B3 it would then look across row 3 and use the slip % from table 2 and determine whether it falls between the start value of 8.001 and the end value of 10. If it did teh answer would be an output of level 1. I have been using the index and match functions, but am having trouble trying to get the horizontal readings to occur on the row in which the degree andle is located. heres the formula ive been working on but i just can get the second part to work if it is dragged.

forum help.PNG

=INDEX($E$2:$E$5002, MATCH(1,(AF2=Degreelevel1)*(1=(IF(AND(AG2>=MIN(C:C,D:D),AG2<=MAX(C:C,D:D)),1,0))),0))

This is from my actual data so doesnt match up with the table data attached. so ill explain which part is which.
The 'e2:e5002' is the lvl colomn, the 'AF2' is a lean angle value, 'degreelevel1' is the degree column, 'AG2' refers to slip.
Once again ill try explain what i want;
i need it to find where in the table the degree of lean is, then i need it to see whether the slip value falls within the start and end value at that angle of lean, if it does then i want it to be come the number in the level column otherwise make it a zero or error or something.

Please help if you can as im stuck!!1
Thanks



PS would also like to add, i know the example pics only has readings that only have 0 degree lean, but i have 34000 rows of data which has varying lean angles hence the need for a formula that i can drag down

Perhaps:

=INDEX($E$2:$E$5002, MATCH(1,INDEX((AF2=$B$2:$B$5002)*(AG2>=$C$2:$C$5002)*(AG2<=$D$2:$D$5502),0),0))

make sure all ranges are the same size (whether named or not).

This may also work:

=SUMIFS($E$2:$E$5002,$B$2:$B$5002,AF2,$C$2:$C$5002,"<="&AG2,$D$2:$D$5502,">="&AG2)

It would be more helpful if you added a worksheet example in .xls format rather than a picture, so it would be able to diagnose and test solutions....

Are you sure the numbers in the Degree column exactly match the numbers in the Lean Angle column (i.e. expand the decimal places to see)...?