Using Vlookup to return a range of data

[lindsay.hawke]

I'd like to use vlookup to find a number in column A and return a range
from column B that starts in the same row and goes down 200 rows. Will
vlookup return a range or can I write my own function that will lookup
without looping?

 

[Tom Ogilvy]

Vlookup won't do it.

Hard to know what you mean by return a range, but perhaps Use match and
Offset if you were returning a range of numbers for summation as an example.