Vlook up with multiple condition vba formula request

Hi Everyone,

I'm still learning this VBA thingy. Unfortunately I am not able to create a simple VBA code for vlook up. let alone add in additional IF function.

Can someone please help me in creating a VBA for attached worksheet as this will be applicable for 50 products.

Basically I just want to populate whatever is in the table on the right in my another table for calculation purposes.


Thanks!