Creating dynamic named renges

[DW1988]

I have created a name range as follows =OFFSET(TubLookup!$A$1,0,0,COUNTA(TubLookup!$A:$A)-1), however I need it to pick up both column A and B because I am trying to do a vlookup to this range.

Any idea how I can make a dynamic named range pick up more than 1 colum.

P.S. I have tried changing the ,0's to ,1's and that doesn't work.

DD1988

 

[RoryA]

The last optional argument is the number of columns, so:
=OFFSET(TubLookup!$A$1,0,0,COUNTA(TubLookup!$A:$A)-1,2)