Creating values based on selection from drop down box
 

Do you have a database of all the selections and the corresponding values in
the next column?

"mproach" wrote:

I am looking to create a worksheet that will automatically populate a value
into c1 based on selection from drop down box in b1.
For instance Picking a selection in b1 would populate c1 with "5.00"
Any help would be greatly appreciated

Thanks

Martin