I have mailed you back your sheet as I have been unable to attach it here ... I have used an IF ( ) function to solve your problem in case you need any assistance in implementing the solution or there is something which is not proper pleas let me know.
Regards, Anand Kumar On Nov 29, 3:26 pm, anil panchal <anil.kan...@gmail.com> wrote: > Dear All, > > Please help me on Data Vadidation :-) > > I have issue in multi validation I want in first cell A1 Anil & B1 I want > list of anil like 5 name & second is A2 Sunil & B2 list 4 names. > > Thanks & Regards > > Anil Kumar > > <http://www.bandoo12.com/wp/ie.php?plg=ie&subs=gmail&elm=sign> > > issue with validation.xlsx > 10KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts