matching rows from different spreadsheets

S

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
 
Top