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