Update respective cell value based on Multiple Drop Down list selections

sample sales tracker.xlsx

Hello Everyone,

I am new to this forum and this is my first Post.
I have attached simple Excel Sheet where I want to Update respective cell values in the table based on Multiple Drop Down list selections.

Solution will be greatly appreciated. Please refer to the attached file.

Thanks in Advance
-Nilesh

See the attached. I put a macro on your button.