Try VLOOKUP() to get the values from a list.
OR
try the CONVERT function which comes along with the Analysis ToolPak add-in.

=CONVERT(A1/12,"in","cm")*100

If this post helps click Yes
---------------
Jacob Skaria


"David" wrote:

Cells A1 (feet) and B1 (meters) are formatted with data validation so that
only specific values can be entered in those cells. Can I format A1 so that
if I select one of the specific values, B1 will automatically display the
equivalent meter value from the defined list of values?