SUM & VLOOKUP working together

[MrManBoy]

Hi All,

I have a table similar to the one below:

Product 1	Product 2	Product 3	Product 4	Product 5	Total Cost
Shoes	Chair	Hat	Belt		$100.00

<tbody>
</tbody>

What I am trying to achieve is getting the SUM total of any products selected under any of the product headings, where the pricing info is listed in another table. I can do this fine but I have found the formula ends up being a short story and I came to see if there was a more, slim down version.

Any help would be great thanks in advance

 

[tygrrboi]

Where is your data?

 

[Muhammad_Usman]

Explain your out put format!