Excel dropdown list dependent on other dropdown list which has the “key” to get the values

I have three sheets, Crops, Varieties and Report as shown in the images below