Hi,

I have a sheet of data. to keep it simple, lets just say it is in A1:B100.
I want to look up values in A, and return what is in B. But I want them to
be in a list on another sheet. But, if there are 5 values in the database
array, that correspond to my search criteria, I only want them to occupy the
first 10 cells of my resut sheet even though they may be in rows 10, 15, 20,
62, and 96 of my database array.

Thanks,

sorry, I meant if there are 5 values I want them to occupy the first 5 cells
of my result sheet. I wrote 10. It may be 10, but I just need a formula to
help.

Thanks

"Duane" wrote:

Hi,

I have a sheet of data. to keep it simple, lets just say it is in A1:B100.
I want to look up values in A, and return what is in B. But I want them to
be in a list on another sheet. But, if there are 5 values in the database
array, that correspond to my search criteria, I only want them to occupy the
first 10 cells of my resut sheet even though they may be in rows 10, 15, 20,
62, and 96 of my database array.

Thanks,