Hi
yes, my fault. Make this:
=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))

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe Gieder" schrieb im
Newsbeitrag ...
Hi Frank,


"Frank Kabel" wrote:

Hi
first: no need to array enter this formula at all. Should do as
non-aaray formula
One way to get multiple returns is the following array 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))))

and copy this formula down.

Note: not completely robust due to the usage of ROW(1:1). If you
for
example enter this formula in row 37 you could change the formula
to:
=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()-ROW($F$37)+1)))

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe Gieder" schrieb im
Newsbeitrag
...
I use this array formula {=IF(F37="","",OFFSET('Priced
BOM'!$AD$3,MATCH(F37,'Priced BOM'!$AD$3:$AD$164,0)-1,-19,1,1))}
and
what it
does is find a part number (-19) baseed on the cost of an item (F
&
AD). If
the cost of two or more items is the same it always lists the
first
part. Is
there a way to to have this formula check to see if the part is
on
the row
above and if so have it list the next part that matches the cost?

Thank you for your help and Happy Holidays
Joe