Thread: How do I link one cell to a range of cell with a drop-down menu?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
davesexcel
 
Posts: n/a
Default How do I link one cell to a range of cell with a drop-down menu?

For the first column you could use a drop down list using data
validation

http://exceltips.vitalnews.com/Pages...Down_List.html

then the other two columns you could use vlook up

http://www.599cd.com/Free/VLOOKUP/?k...LOOKUP&CPC=0.2


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=523985

Reply With QuoteReply With Quote