Hi Manoj, Thanks for the Information, But when i individually insert range_lookup value 0 it shows #NA value in contact person, Hence i request you to please give me the Step by step details from starting to do the Same(from how to make drag drop list to Last one)
Looking foreword for your co-operation. *Please Help me for the above Query!!!!!!!!!!!!!!! * * * * * *Thanks * *Jocky * On Mon, Jan 17, 2011 at 1:03 PM, Manoj kumar <[email protected] > wrote: > Attached for ur reference.... > > > > Regards, > Manoj Kumar > > > On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta <[email protected]> wrote: > >> >> Hi, >> >> I made a Excel sheet with help of V lookup using the Data validation, but >> my formula shows unknown error. hence pls explain me the step by >> step procedure for the same. >> >> >> Regards >> Jocky >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 [email protected] >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- ---------------------------------------------------------------------------------- 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
