Populate the value of a specific cell based on two other dependant validation lists

[Louisa Venter]

Dear Forum members,

I want to populate the value of a specific cell based on the choices made from two other dependent validation lists.

I am attaching a workbook that explains what I need to do.

I consider myself a novice Excel user. Please explain in very simple terms. Assume that I know nothing