I created a "pull down menu" using data validation which allows the user
to select one of 3 choices (cell A48). When the user selects this, I
want the corresponding data values from rows 41 thru 43 to drop in to
cells B48 and C48. I can then use those in some calculations. Once I
have this method down I will be increasing the number of possibile
selections. Any help would be appreciated.


+-------------------------------------------------------------------+
|Filename: a1.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4517 |
+-------------------------------------------------------------------+

--
arbutus
------------------------------------------------------------------------
arbutus's Profile: http://www.excelforum.com/member.php...o&userid=32761
View this thread: http://www.excelforum.com/showthread...hreadid=525935