I have 10 styles of furniture with 10 different variations thus 10 different pricing. I am currently using a index match formula. I allow for 5 different items to be purchased at a time thus 5 rows with the index match formula. if 2 items are purchased, it leaves 3 rows. those three rows show up with a #N/A in it. I want it to have a zero conclusion if nothing is entered . Any thoughts
=INDEX($BB$17:$BO$501,MATCH($B$19,$BA$17:$BA$501,0),MATCH($C$19,$BE$6:$BO$6,))
=INDEX($BB$17:$BO$501,MATCH($B$19,$BA$17:$BA$501,0),MATCH($C$19,$BE$6:$BO$6,))