Autofill column by looking at values in two different columns

[KarolinaS]

Hi,

I'm trying to autofill a column in excel, after having chosen values in two different columns from drop down lists. Basically it's a product code that I want to autofill itself in a column after a unit size and blend description is chosen, from two drop down lists in two other columns. Every blend + size = a unique product code.
Any tips on how I can easily do this?
I currently have one of the drop down lists on a different sheet (marked lists) and one the other one I simply made straight from the data validation as it was short.

The yellow square is where I want the autofill, based on the two values in the red squares.

Thanks!

 

[Peter_SSs]

Welcome to the MrExcel board!

The yellow square is where I want the autofill, based on the two values in the red squares.

Obviously we cannot see that.
I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be. We can also then copy/paste your sample data to test with.