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.

--
regards,
Tom Ogilvy



wrote in message
ups.com...
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?