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

"wmjenner" wrote in
message ...

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

Thanks,
Bill


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile:
http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=550661