Hi

I've been trying to construct a formula to lookup values in a table based on another set of criteria

What I have is a table of rates each line relates to a different place in the world designated by a 3 letter destination code and relates to breakpoint by weight

I'm trying to write a formula that will lookup the 3 letter code in the first column and then look in the horizontal row at the appropriate weight breakpoint.

heres an idea of how the sheet looks at present

Destination Airport Code Min -50 50 100

Abu Dhabi AUH DH 5.00 0.25 0.25 0.25
Accra ACC GH 20.00 1.15 1.15 1.10
Adelaide ADL AU 10.00 1.60 1.60 1.30
Atlanta ATL US 5.00 0.70 0.70 0.68
Auckland AKL NZ 10.00 1.25 1.25 1.20
Bahrain BAH BH 15.00 0.85 0.85 0.65


So what I'm trying to do is to create a drop down list of the airport codes and then enter a weight, lets say 45 kgs and then have a formula retrieve the corresponding rate so 45kgs would be under 50 kgs to say ADL (Adelaide) which would return a value of 1.60.

I think I need to use the IF command to determine the colmum along with either Vloopkup or hlookup to determne the rate but I'm draawing a blank, if anyone can help I'd be really grateful

Thanks

Ian