Sorry, possibly a straightforward answer no doubt, not for me as a newby... Refer to the attached Workbook. Two worksheets 1. Pricelist; This is where line items (products) are collated along ... brenden1973 In G2: =IFERROR(INDEX(PRICELIST!$D$3:$F$5,MATCH(C2,PRICELIST!$A$3:$A...