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 -~----------~----~----~----~------~----~------~--~---
