View Single Post
  #2   Report Post  
Faz
 
Posts: n/a
Default Show Drop Down Arrow


It sounds like the cell you're talking about has a validation, where it
can only take certain values from a list, which you must have put in.
To get the arrow to show all the time, you can use a combo-box, it's
the same thing only it returns a number in a cell reference, rather
than changing the actual text in the cell.

What you have - Cell with validation, returns text "very small" in that
cell
Combo box - Cell reference could be A1, returns number in A1, eg 4.

1 red
2 orange
3 yellow
4 green

This is 2 columns, the 2nd is the list of values that cell could take.
The cell reference linked in with the combo-box returns a numbered
value, depending on which value you choose in the drop down box, ie
selecting yellow returns the number 3 in the cell reference.

If you ever need this value later in the spreadsheet you could simply
use the VLOOKUP function on the 2 columns above
=VLOOKUP(Cell reference,Table array,2)

An example might be
=CONCATENATE("You wish to buy a ",A1," car.")
Where A1 is the VLOOKUP function, looking up the colour
If the combo box is on red, the formula returns
You wish to buy a red car.


--
Faz
------------------------------------------------------------------------
Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830
View this thread: http://www.excelforum.com/showthread...hreadid=476747