 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2006Help for Vlookup
I have two sheets one is book 1 and other is book2.xls . In book 2 I have Column A which has Names like x, y and z and against these name there are certain information in column B. I also have book1.xls Containing name of the person( x, y, and z). Now what I want if through the help of auto filter in book2.xls if I select name of x, all the information which has in book2.xls against x should be automatically incorporated in book1.xls below the name of X and so on for y and Z. I know we can do it with the help of vlookup but i am not getting it. Please help me.  Signaturemangesh In Book1.xls, Sheet1, cell B1, put this formula..... =VLOOKUP(A1,[Book2.xls]Sheet1!$A:$B,2,FALSE) In cell C1 put this formula =VLOOKUP(A1,[Book2.xls]Sheet1!$A:$Z,3,FALSE) Notice the only difference between the two is the number just before the FALSE, which indicates which column of data you wish to retrieve from Book2.... Continue across row one with these formulas, increasing the number by 1 each time you change columns and then copy all of the formulas down as far as you have data in column A........... Vaya con Dios, Chuck, CABGx3 > I have two sheets one is book 1 and other is book2.xls . In book 2 I > have Column A which has Names like x, y and z and against these name [quoted text clipped - 6 lines] > I know we can do it with the help of vlookup but i am not getting it. > Please help me. Is there anyway to transpose more than one column at a time ? I sometimes need to merge lots of data! Jenny > In Book1.xls, Sheet1, cell B1, put this formula..... > [quoted text clipped - 31 lines] > > mangesh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6746 > > View this thread: http://www.excelforum.com/showthread.php?threadid=505727 To just bring in data from another workbook, try just this formula in A1 and drag it around...... =[Book2.xls]Sheet1!A1 Vaya con Dios, Chuck, CABGx3 > Is there anyway to transpose more than one column at a time ? > [quoted text clipped - 38 lines] > http://www.excelforum.com/member.php?action=getinfo&userid=6746 > > > View this thread: http://www.excelforum.com/showthread.php?threadid=505727 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.