Help creating a Combo Macro to place data into another cell

Hi folks,

I'm new here, new to Excel 2010, I know what a macro is, even though I'm pretty useless at creating them.

So far I've gotten through by looking at example code and modifying it. I've honestly got no idea how anyone got stuff done before Google!

Anyhow...

In Worksheet "Supply Calc" I've a combobox drop down list. The list pulls names from a "name range" called "Zone_Types" in a worksheet called "DATASHEET" which is a 2 column table with NAMES in column A, and a numeric value in column B.

What I would like is when I select an item from the drop down ComboBox (named "TOL" by the way) for the numeric value associated with it (1 cell over) to appear in cell B25 on the "Supply Calc" worksheet.

I know there may well be easier ways to do this, and if there are... by all means suggest them!

This is my first post, I'm sorry if I've missed something, I've done some basic searches, but without knowing some of the terminology to use, it's been tough on this one.

I also tend to ramble... so shutting up now. (thanks)