I did.

"Frank Kabel" wrote:

Hi
have you entered my formulas as array formula?

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe Gieder" schrieb im
Newsbeitrag ...
The formulas I have tried are as entered starting in C37:

=IF(F37="","",OFFSET('Priced BOM'!$AD$3,MATCH(F37,'Priced
BOM'!$AD$3:$AD$164,0)-1,-19,1,1))

C37 F37 C37 Result SB
B32281006-102 $182,732.82 B32281006-102 correct
B32281006-101 $182,732.37 B32281006-101 correct
B32281006-103 $56,851.23 B32281006-103 correct
B32281006-104 $56,391.69 B32281006-104 correct
B32281006-109 $29,420.28 B32281006-109 correct
B32281006-109 $29,420.28 B32281006-110 wrong
368659-3 $28,218.75 368659-3 correct
368659-3 $28,218.75 368659-4 wrong
363576-6 $23,786.97 363576-6 correct
391066-1 $15,014.70 391066-1 correct
4085962-1 $11,669.16 4085962-1 correct
4085962-1 $11,669.16 4085962-2 wrong
and others..

And I used your formula:
=IF(F37="","",INDEX('Priced BOM'!$K$3:$K$164,SMALL(IF(F37='Priced
BOM'!$AD$3:$AD$164,ROW('Priced BOM'!$AD$3:$AD$164)),ROW(1:1))-2))
And received the same results as above.

Thank you and Best Regards
Joe