Lookup Code and return Price from Price Band

Hi - I'm a new member with a problem I hope will be simple to most and an easy solution can be offered.

As per the sample attachment, I have a list of data spanning over 3,000 lines. I want to lookup a code value, then look up a quantity and return a relevant price from the list. The price will be either equal to the quantity or the next price above if not an exact match (see criteria explanation in cells F2:G4).

One added complication is that my lookup code may not now exist, as it is cross referencing an old price list. Therefore, if my code is not within the list, I need it to return an error.

I am imagining a formula using INDEX, MATCH and LOOK UP, but I just can not crack it myself.

Any help will be gratefully received! I hope it is clear what I need and a very simple solution is staring me in the face!

Many thanks