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

See response in .excel

--

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