match rows from spreadsheets-Please help.

[sohum.shah]

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

 

[Bernard Liengme]

Use VLOOKUP
If you tell us where each block of data resides, I will give a more detailed
answer.

 

[sohum.shah]

What do you mean?
where each file is on my computer?

 

[Bernard Liengme]

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

 

[sohum.shah]

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"

 

[Bernard Liengme]

Now I am confused!

 

[sohum.shah]

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.

 

[Erik Veldkamp]

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