I think I understand your formula, but is there anyway to paste it into another location besides c6 on the DATA tab? Pasting it into c6 changes the data in that cell. Also, the formula is only covering C4 to I4 instead of extending to B4. Is it possible for me to change it to extend to B4 without messing up the formula you created? I assume so, but this is new to me.

Also, how can I link this formula to a dropdown menu on the Product Comparison tab? I tried using data validation but I am doing something wrong, as I am unable to link the formula to a Part Number driven dropwdown menu on the Product Comparison tab.

Thanks in advance!