vlookups error message

  • Thread starter Thread starter wmjenner
  • Start date Start date
W

wmjenner

I am trying to use Alan Beban's famous vlookups formula to find multipl
occurences within an array. I have copied the formula down to accomodat
all possible occurrences of the lookup criterion, yet I keep getting th
error message "Select at least (x) rows" wherever the looked up valu
has more than a single occurrence. I'm not sure what "rows" are bein
referred to in this message since, as I said, I've copied down enoug
to cover the maximum potential answers. Anyone familiar with this?

Thanks,
Bil
 
Hi!

I've never used Alan's add-in but I've seen the Vlookups function discussed
here.

I think you have to select a range of cells as an array and then enter the
formula rather than entering the formula in a single cell and copying. I may
be wrong but I'd try that.

Want an alternative solution using native functions that doesn't require an
add-in? This is fairly easy to do using native functions. If so, just
provide the details.

Biff
 
Here's a small sample file: 16kb

http://cjoint.com/?gldXzR6oLA

The formula in column B needs to be copied down to enough cells to return
all the possible matches. I have colored the cells where I copied the
formula to. Make a selection from the drop down and see what happens.

Biff
 
Thanks a lot, Biff. I will study this tomorrow but just looking at it
it looks like a great solution. Thanks again!

Bil
 
It does the same thing as Alan's Vlookups UDF but doesn't require the
"overhead" of an add-in.

Biff
 
Back
Top