DropDown List if Matching

Dear All,

I don't know how to explain my issue because as I mentioned earlier in my first post that I'm new to excel world and I loved it because of ExcelForum.com.


Anyway me problem is that I have table contains (Countries, Weights , Rates ) and I made dropdown list for the (Countries, Weights) and I would like to have the rate as an Output based on the (Countries , Weight ).


for Example :


Weight Bahrain KSA ETC,,,,
0-75 18
76-250 0.24
251-500 0.24
501-1000 0.24
1001-2000 0.24
2001-3000 0.22
3001-Over 0.22


If I selected from the Weight Range from the dropdown list I need the Output Rate direct to come out.



I uploaded My example for more clarification and I hope to hear from you soon.

Hi ,



I tried it but it says:


Error.JPG


Thanks in Advance.

Apologies, my fault. I said B2 when I meant C2.

Attached is your file with the formula included.

BSB.

I don't know how to thank you so much you really helped me a lot , one more thing if it's possible, can you explain to me the formula as well if you have any training materials for the ( index formula ) to study from

Originally Posted by BadlySpelledBuoy

Apologies, my fault. I said B2 when I meant C2.

Attached is your file with the formula included.

BSB.

Happy I could help

Have a look at the link below. It will explain INDEX/MATCH far better than I can.
http://www.contextures.com/xlFunctions03.html

Don't forget to mark the thread as SOLVED if you're happy you have your solution.

BSB.