how to do a dynamic ranges?
 

Hello,
How do you do a dynamic range?

I have a range of numbers that take up 30 coloumns.
But depending on the value of my control cell, I only want to select a
range of them in my VLOOKUP. How do I do this?


--
MadCow
------------------------------------------------------------------------
MadCow's Profile: http://www.excelforum.com/member.php...o&userid=33161
View this thread: http://www.excelforum.com/showthread...hreadid=529775

how to do a dynamic ranges?
 

Hi

create a name containing a formula like this

=OFFSET(reference,rows,cols,height,width)

You can take a look to this post

http://jldexcel.blogspot.com/2006/03...-excel_08.html

in my blog


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=529775

how to do a dynamic ranges?
 

Ahhh thank you, that worked perfectly with my formula.
:D

Thanks


--
MadCow
------------------------------------------------------------------------
MadCow's Profile: http://www.excelforum.com/member.php...o&userid=33161
View this thread: http://www.excelforum.com/showthread...hreadid=529775