I have an Excel worksheet where I'm trying to display a value in a field
based on the state selected in another field.

For example if the state is TX, the value is 100, if the State is FL, the
value is 120 etc.

I have the states listed on a worksheet in column A and the corresponding
values in column B.

Then I set up the second worksheet, same workbook with my other information.
On this worksheet I want to select a state from a drop down (which I've
done) and based on that selection populate the next cell (i.e. E1) with the
appropriate value based on my look up table.

How do I do this?

Your help is much appreciated.