Look Up in Ranges

[jimd1768]

I have a table that I want to return a monetary value.

The result is a %. For example, if the % is 74% it falls within a range and should return a value of £1.50

I have attached the table to view.

I have tried an Hlookup but can't seem to return a value.

If someone could please cast an eye over and see if they could help me with this.

Thank you