3D Dynamic Range?

[easy]

Is it possible to have a 3d dynamic range for use with a vlookup formula?


On a sheet called "contents", I have a Vlookup in column B which needs to refer to a dynaic range in columns F & G starting in F2 is this possible?

[easy]

Sussed it from ozgrid - excellent site

LookUp range defined as:

=OFFSET(Contents!$F$1,0,0,COUNTA(Contents!$F:$F),2)

and VLOOKUP(A1,LookUp,2,FALSE)

Much more satisfying when you can find the answer yourself but has took me 2 days to work it out