Hello,

I want to use a different drop-down list in a cell based on the content of another cell.

Example:

IF A1="BF1" - for current cell, use drop-down list in column G
IF A1="BF2" - for current cell, use drop-down list in column H

Is this possible? If not, is there another way to do this?

Best regards and thanks in advance.