W
wmjenner
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
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