Hi,
I have been trying to figure this out for a while and have hit a wall.
I am unable to adapt the following formula to ignore empty cells.
=IFERROR(INDEX('order form'!C$9:C$500;SMALL(IF('order form'!$D$9:$D$500>0;ROW('order form'!$D$9:$D$500)-ROW('order form'!$H$9)+1);ROWS('order form'!$H$7:H7)));"")
The empty cells occur when there is a gap in the product identifier rows (e.g. Code #, Ordered, Product and Description).
When an ordered quantity is (accidentally) entered in the order form page D column (D15:D16) the formula returns a zero in the Orders page (e.g. B10:G11). Ideally I would like to reference the order form Code # column (order form D8:D500) and if there isn't a product code return some text identifying an order form error.
Any suggestions appreciated;
Regards.
Bookmarks