Working in Sheet 1 and in cell  B2 I am using IF(B2=10,Sheet 2 cell C2,””) 

In sheet 2  cell C2 is having data validation list in it but it is not showing data validation list in Sheet 1 after using formula. 

Can anyone help please?

​Working in Sheet 1 and in cell  B2 I am using IF(B2=10,Sheet 2 cell C2,””) In sheet 2  cell C2 is having data validation list in it but it is not showing data validation list in Sheet 1 after using formula.  Can anyone help please?  Read More

​