this would be easier if you uploaded the actual workbook instead of just your image, but i think you can accomplish what you're looking for with a pretty simple helper formula... are there really only those 6 products? if there are a lot of products this would get tedious to manage, but something like this should work:
in column I
then in column J
(untested)
i could also see doing this with a macro, if you don't like the helper column.
probably other ways as well, that's just the first thing popping into my head.
Bookmarks