If Statement? Update text in one cell based on another

  • Thread starter Thread starter Kesbutler
  • Start date Start date
K

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
 
In the other cell, place a Data Validation pull-down that references F39 thru
F41
 
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?
 
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??
 
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.
 
Back
Top