Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation?
I have two columns..I have written the below example to explain
A B 1 a 2 b 3 c 4 d 5 e 6 f what I want to do is put a dropdown menu on a sheet, that when "1" is selected, in another cell, "a" would be displayed, and so on for all the way to "6"/"f" I have selected all of the numbers in the A column and name/defined it as "points". I have done the same with all in column B and names it "mm". I basically want someone to be able to select one of the points, and have it automatically display the mm value....any help would be greatly appreciated.. Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation?
See response in other groups.
-- HTH RP (remove nothere from the email address if mailing direct) wrote in message oups.com... I have two columns..I have written the below example to explain A B 1 a 2 b 3 c 4 d 5 e 6 f what I want to do is put a dropdown menu on a sheet, that when "1" is selected, in another cell, "a" would be displayed, and so on for all the way to "6"/"f" I have selected all of the numbers in the A column and name/defined it as "points". I have done the same with all in column B and names it "mm". I basically want someone to be able to select one of the points, and have it automatically display the mm value....any help would be greatly appreciated.. Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |