Round the number, and look up the match correspond value

[hpbaxxter]

Hello,
I have columns with values (The yellow columns),
and I have a cell of Sum (E5)
I need a formula to round the result of H6 and look up the math in the yellow columns and insert the correspond value .
And thanks in advance.

 

[hpbaxxter]

But how to change the Match formula when I change the Yellow numbers to Random and unorded nemberS.

 

[Dave Patton]

Thanks for the feedback

 

[hpbaxxter]

Thanks for the feedback

But how to change the Match formula when I change the Yellow numbers to Random and unorded nemberS.

 

[Dave Patton]

But how to change the Match formula when I change the Yellow numbers to Random and unorded nemberS.
You could start a new thread.