I want to simplify an attachment, have a validation list like this:
A | B
Cost 1 | Rs. 10
Cost 2 | Rs. 20
Cost 3 | Rs. 30
The value in the cell A10, for example, must be validated by list, but I want:
- Displays the list cost 1/Cost 2/Cost 3
- Selection of cost 2 place the value Rs. 20 in cell
Have you any idea how to program this?
Bookmarks