referencing data from a table
 

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

referencing data from a table
 

One way ..

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

Copy B48 to to C48
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"arbutus" wrote in
message ...

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

referencing data from a table
 

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---