find dimensions of named range

a vlookup function returns one result so not much to test as dimensions go ;-)

Originally Posted by JosephP

a vlookup function returns one result so not much to test as dimensions go ;-)

Not if you specify the function to return several columns..

eg

=vlookup(lookupThis,lookHere, {2,3,4}, false) 
or
=vlookup(lookupThis, lookHere, COLUMN(B:D), false)

will return a matrix/row vector of dimension 1x3


Didn't really find an answer to my original question, couldn't get your technique to work AndyLitch. I might be stupid or it's a mac thing. However, it's no longer an issue as my named range sorted itself out.

Thanks for replies!