If Statement? Update text in one cell based on another

[Kesbutler]

I need to have one cell populate with specific text based on the choice of
the user. Example: User can select from three choices in Column F (rows
39,40,41). I would like another cell in the workbook to display that choice.

Thanks

 

[Gary''s Student]

In the other cell, place a Data Validation pull-down that references F39 thru
F41

 

[Kesbutler]

I need the other cell to automatically populate with the user's choice. That
data is used in some auto calculations else where in the workbook. I'm not
seeing that ability using validation. Am i missing it?

 

[Gary''s Student]

Let's say the reference cell is Z100 and the choices are F39, F40, and F41.

I allow the user to make a choise by use data validation in Z100 to pick one
of the three choices.

In your application, how is the user chosing??

 

[Kesbutler]

Because of the way the sheet is set up to collect much data they just put an
"x" in the cell for their selection. I could change the layout and use data
validation.