how to do a dynamic ranges?

[MadCow]

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]

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/small-databases-management-in-excel_08.html

in my blog

 

[MadCow]

Ahhh thank you, that worked perfectly with my formula.


Thanks