software

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: www.excelforum.com/member.php...oamp;userid=33161
View this thread: www.excelforum.com/showthread...hreadid=529775
Hi

create a name containing a formula like this

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

You can take a look to this post

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

in my blog--
jordun------------------------------------------------------------------------
jordun's Profile: www.excelforum.com/member.php...oamp;userid=33118
View this thread: www.excelforum.com/showthread...hreadid=529775
Ahhh thank you, that worked perfectly with my formula.Thanks--
MadCow
------------------------------------------------------------------------
MadCow's Profile: www.excelforum.com/member.php...oamp;userid=33161
View this thread: www.excelforum.com/showthread...hreadid=529775