Help with lookups and arrays

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have two worksheets, "Pricesheets" and "Orders".

Columns in Pricesheets (2500 rows):
- Customer (text)
- Plant (text)
- SKU (text)
- Standard lengths (text, like this: 48' 50' 60')

Colums in Orders (10,000 rows):
- Customer (Text)
- Plant (text)
- SKU (text)
- length ordered (integer)

For each order (a row in Orders), I want to find the matching row in
Pricesheets (based on Customer, Plant and SKU), then return a 1 if the
length ordered was listed in "standard lengths".

I've tried combinations of array-entered SUM(IF()) and FIND(text, within)
functions, but I can't get it to work. On top of which, it takes a heckuva
long time to process.

Is there a more elegant solution?

Thanks.



.

Quantcast