Lookup Code and return Price from Price Band

I think it is almost there, many thanks for the quick responses and your time (much appreciated).

I have attached an updated spreadsheet (Price Test 2) showing what I am trying to achieve and comments in red. I hope I am not overcomplicating and looking for too much?

Cheers