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

In Report sheet the user can select the Crop (D1), which is a dropdown list with values taken from the Crops sheet.

So I need the Variety dropdown list take its values from the Varieties sheet, taking the crop(D1) as a “key” (sheet Varieties, column A) to fill the list with the corresponding variety values (Sheet Varieties, column B) as shown in the image below

Looking for a solution, I considered the INDEX with MATCH functions, as well as VLOOKUP function but none of these does exactly what I need.

Any Idea please? I would like not to use VBA but maybe is the only way?