Define a name (Menu: InsertName...) and then use the offset function
Name: range
Formula: =OFFSET(Sheet9!$D$7:$D$9;0;Sheet9!$B$7-1)

Also see encl. zip-file:
http://www.excelforum.com/attachment...tid=3494&stc=1

Hope it helped
Ola Sandström


+-------------------------------------------------------------------+
|Filename: Book4.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3494 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378959