According to me this is the best formula for Vlookup, Check the attached file.
Regards, Ajay On Thu, Sep 4, 2008 at 10:55 AM, shaily goel <[EMAIL PROTECTED]>wrote: > > hi Arjum, > > pl find attached file > > Regards, > Shaily > > On Thu, 04 Sep 2008 Arjunm1984 wrote : > > > >Hi Shaily, > > > >If you dont mind! Can u please send this attachment to me aswell.. coz > >I have a similar issue .. > >Thanks, > >Arjun > > > >On Aug 31, 7:21 pm, "shaily goel" <[EMAIL PROTECTED]> wrote: > > > Hi , > > > Mayank, thanks a lot > > > > > > Bye > > > > > > Shaily > > > > > > On Sun, 31 Aug 2008 Mayank Patel wrote : > > > > > > > > > > > > >Hi shaily, > > > >I saw ur problem i think this is because u have made the entire cell > of > > > >lookup value constant u only need to constant the column and not the > row. > > > >solution is given below > > > >=VLOOKUP($A$3,MASTER!$A$3:$D$11,COLUMN(MASTER!B4),FALSE) > > > >This should be =VLOOKUP($A3,MASTER!$A$3:$D$11,COLUMN(MASTER!B4),FALSE) > > > > > > >Rgds > > > >Mayank > > > > > > >On Sat, Aug 30, 2008 at 3:27 PM, shaily goel < > [EMAIL PROTECTED]>wrote: > > > > > > > > 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. > > > > > > >-- > > > >Regards > > > >Mayank Patel > > > >9822978041 > > > >9422749110- Hide quoted text - > > > > > > - Show quoted text - > > > >> > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
vlookup(1).xls
Description: MS-Excel spreadsheet