how to do a dynamic ranges?

**MadCow** · 04-04-2006, 03:45 PM

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?

**jordun** · 04-04-2006, 04:12 PM

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