Hi Guys,

I was wondering if there was a work sheet function that returns a range rather that one cell. I'm looking to use a vlookup, but I need to find the range first. This would be very similar to the using Range(A:2, D:10) when coding VBA. I expect my sheet formula to look roughly like this:


vlookup(A2,Range(Index(2,Match()),offset(Index(2,Match()),20,1)),2,false)


I've call the function I'm looking for Range. I suppose another thing is can Vlookup take a function that outputs a range as an arguement as I could always write one. Just I thought Excel would have come with a useful function such as this.

Any ideas?

Thanks again ,

T