Dear experts, I have 1 cell (A2) where data validation exist based on drop down list. I want to use formula based on the drop down value.

e.g. If (A2) = "TIN" then it should allow value range between 3000000000 and 3999999999 and IF (A2) =Blank it should not contain any value and if it (A2) = "FIN" it should allow value starts with 3 but only 15 digit and if (A2) = "CRNo"then it should allow only numeric value

Regards,

Prad

Not sure I understand what it is you want to do. A cell can contain

eithera Formula or Data but not both.

So with your Drop Down in cell A2

where is your Data going to be

and what happens if it does not conform to your list?If you could explain what it is your trying to accomplish it would help.

MIKE

Ask Your Question

Weekly Poll