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