Hi Atul,
this formula is not working for rows i think that i am doing some mistakes pl check why it is not working for cell b4 what is the mistake Thanks Regards, Shaily On Thu, 28 Aug 2008 SINGHAL, ATUL. 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 > > > > > >This Message was sent from Indian Oil Messaging Gateway. The information >contained in this electronic message and any attachments to this message are >intended for the exclusive use of the addressee(s) and may contain >proprietary, confidential or privileged information. If you are not the >intended recipient, you should not disseminate, distribute or copy this >e-mail. Please notify the sender immediately and destroy all copies of this >message and any attachments. > > >> --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Book1_1_.xls
Description: Binary data
