Hi Jocky, The reason you are getting #NA error because your criteria for "* table_array"* * * (*This is the table of data that VLOOKUP searches to find the information you are after.*) is wrong. Your range should start from column B and not A because "the value you want to find in the B column of the table.
And I think this is the only mistake u have made in the formula.... Some links :- http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel http://www.techonthenet.com/excel/formulas/vlookup.php I think this help u out.... Regards, Manoj Kumar On Mon, Jan 17, 2011 at 8:40 PM, jocky Beta <jocky6...@gmail.com> wrote: > > 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 < > manoj.vishwakarma...@gmail.com> wrote: > >> Attached for ur reference.... >> >> >> >> Regards, >> Manoj Kumar >> >> >> On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta <jocky6...@gmail.com> 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 excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> 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 excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > 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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
