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