pulling inventory number from a range

I have an inventory list (non-sequential) and I want to pull only the items with id codes that are with in 4 different ranges.

Please see attached file.

I would like to populate column A with the results, search paramiters are in Q3 and S3.

I can get it to work on a small scale but my inventory list is 10143 rows long.

Pease help.

NBVC helped me before and got me to where I am now. but somewhere along the line I screwed it up.

Thanks

Please Login or Register  to view this content.

ok so I have it set up for 2 ranges but it will not pull from the first range.

please help

Not sure for the life of me why your sheet was so large. Anyway, a dataset as large as yours, you really need a non-array solution or your sheet is going to grind into the ground performance-wise.

Addition of a simple "helper" column to your Inventory sheet....it watches the four possible ranges you might setup on the Master and if the row qualifies as a match on ANY of the ranges, it displays a new INDEX value.

Then on the master, we use a simpler non-array INDEX/MATCH on that helper column to transfer over the matching values.

As you change your values in Q and S, the entire APN list will reassert.