Thanks a lot atul. it was really helpful On Thu, Aug 28, 2008 at 10:49 AM, SINGHAL, ATUL. <[EMAIL PROTECTED]> wrote:
> Hi Rishi, > > The formulae in the enclosed file may help you. > > Regards > Atul > > > -----Original Message----- > *From:* rishi [mailto:[EMAIL PROTECTED] > *Sent:* August 26, 2008 11:30 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Vlookup Help > > Hi All, > > > > I have a couple of problems : > > 1. > > I wanted to know if there is some short cut for using vlookup multiple > times . > > For eg, > > I have a table with Name , Phone no ,address..etc in a workbook. > > I have a few names from the master list in the second sheet . > > Now I want to use vlookup to pull all the details from the first sheet i.e > phone no , address , etc . > > I don't want to write individual vlookup for each column . > > Wanted to know if there is any short cut . > > > > 2. > > > > With similar sheet , > > If the names in the second sheet have some minor spelling mistakes,is it > possible to still pull out data from the first sheet . > > For eg. > > Shree Ram in the first sheet could be Sri Ram in the second > > OR > > Ram Ltd could be Ram Ltd. In the second sheet . > > > > Using vlookup in such a case is not working...so is there any other way > someone can suggest ? > > > > Thanks in advance . > > > > Rishi > > > > > > -- Thanks and Regards, Rishi Dakalia +91 9811182746 --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---