View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] lindsay.hawke@cms.k12.nc.us is offline
external usenet poster
 
Posts: 2
Default Using Vlookup to return a range of data

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?