Populating a cell based on a drop down box in a different cell

Hi,

Thanks for responding

Kind of - attached is what i'm looking at (with sensitive data removed and with no drop down boxes in B) so its basically a way of checking stock.

I can do the simple formula that figures out the difference but I'm having difficulty populating the C column from the selection in the B column.