Hi

I would like cell D7 to display a drop down list (already set on another worksheet Name = POSITION) if cell S4 >1

I have tried =if($s$4>1,position) but this is not working

thanks