Multi data list Validation

[nadjalil]

Dear All
i need to 3 data list and need to validate one of them at a time in A3 based on values in B3. I am attaching a sample file.
please guide me how i can do this.

thanks for your help.

Kind Regards

 

[NARAYANK991]

Hi ,

Use an IF statement.

Narayan

 

[Syedali]

My try. Comparatively Mr. Narayan did is good.

 

[nadjalil]

Thanks Narayan Sir for your help...