LOOKUP IF AND COMBO Help please...

Hi,

I am new to the forum so forgive me if I break any 'rules'

I have a problem I wonder if anybody can help with as I'm going around in circles.

I have my excel spreadsheet set up as follows:

Min Max (incl VAT)

£0.01 £5.00 £1.20
£5.01 £10.00 £1.40
£10.01 £15.00 £1.70
£15.01 £20.00 £1.80
£20.01 £25.00 £2.40
£25.01 £30.00 £2.80
£30.01 £35.00 £3.40

I am looking for a formula that I can use that refers to this table.

So, elsewhere on the spreadsheet, I want an 'input cell' where I can insert a price (lets say £7.32)
I need a formula that will basically say, if £7.32 falls between range £0.01-£5.00 (which it does't!) then display £1.20
So because £7.32 falls between the range £5.01 and £10.00, I would like a value of £1.40 to be displayed so that I can use that in future calculations.

I've tried =IF statements, and VLOOKUP and HLOOKUP, but none seem to fit my needs. (Plus I may be doing it wrong).

Any help much appreciated - thanks,
Phil

Thanks very much for your rapid responses. These may very well work, but I don't think I have the experience to 'tweak' them.

I've attached a sample spreadsheet which I'm sure will help you guys to help me.

Hopefully the file has attached.

Pure genius - thank you all.

You can't imagine the hours I spent trying to achieve that.

1000 thankyous!