referencing data from a table

[arbutus]

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 |
+-------------------------------------------------------------------+

 

[Max]

One way ..

Put in B48:
=IF(A48="","",OFFSET(INDIRECT("A"&$A48),,COLUMN(A1)))

Copy B48 to to C48

 

[Max]

Put in B48:

=IF(A48="","",OFFSET(INDIRECT("A"&$A48),,COLUMN(A1)))

My apologies, correction to earlier formula

Put instead in B48:
=IF(A48="","",OFFSET(INDIRECT("A"&MATCH($A48,$A$41:$A$43,0)+40),,COLUMN(A1))
)

Copy B48 to to C48


---