If cell equals a text then insert a number, (text cell comes from a data validation)

[floridashaughn]

I have created a data validation cell (user must choose B, C, or D). I need a different cell to automatically fill in a number depending on the letter chosen. For example, if the user chooses B, then the cell should equate to 0.57. If the user chooses C then the value should read 0.85. Thank you,

[Ace_XL]

Try on these lines..

=LOOKUP(A1,{"B","C","D"},{0.57,0.85,0.97}

[floridashaughn]

Whoo hoo!!! That was perfect!! Thank you so much Ace_XL!!