 |
 | 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 / October 2006match rows from spreadsheets-Please help.
how do i match rows from different spreadsheets to a directory: Directory ZIP No. 80001 1 80002 2 80003 3 80004 4 80005 5 80006 6 80007 7 Sheet 1: ZIP POP 80001 134 80003 9890 80006 9489 80009 883 =>: Directory ZIP No. POP 80001 1 134 80002 2 80003 3 9890 80004 4 80005 5 80006 6 9489 80007 7 Use VLOOKUP If you tell us where each block of data resides, I will give a more detailed answer.  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > how do i match rows from different spreadsheets to a directory: > [quoted text clipped - 26 lines] > 80006 6 9489 > 80007 7 What do you mean? where each file is on my computer? No -the sheet name and the rows & columns for Directory, and for the Sheet 1 stuff It will make it easier to give you a working formula SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > What do you mean? > where each file is on my computer? The Directory has the field "ZCTA" in Column A in Sheet 1 Sheets 2-6 have Column A as "ZCTA" and Column B as "POP" On Oct 27, 11:43 am, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca> wrote: > No -the sheet name and the rows & columns for Directory, and for the Sheet 1 > stuff [quoted text clipped - 8 lines] > > What do you mean? > > where each file is on my computer? Now I am confused! SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > The Directory > has the field "ZCTA" in Column A in Sheet 1 [quoted text clipped - 16 lines] >> > What do you mean? >> > where each file is on my computer? The directory is in sheet one the other 5 sheets have the ones that need to be matched in columns c-g of the directory. On Oct 27, 11:50 am, sohum.s...@gmail.com wrote: > The Directory > has the field "ZCTA" in Column A in Sheet 1 > Sheets 2-6 have Column A as "ZCTA" and Column B as "POP" So probably you need in Sheet1, cell C5 =VLOOKUP(A5,Sheet2!A:B,2,FALSE) and so on for values from sheet 3 to sheet 5 Erik > The directory is in sheet one > the other 5 sheets have the ones that need to be matched in columns c-g [quoted text clipped - 4 lines] >> has the field "ZCTA" in Column A in Sheet 1 >> Sheets 2-6 have Column A as "ZCTA" and Column B as "POP"
|
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.