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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

match rows from spreadsheets-Please help. 7
choosing first instance of non zero data 0
Creating Different Headers in Word 0
Arriving at totals 2
Two Totals from the same column 2
Index match with multiple criteria(different than usual) 0
Index match with multiple criteria(different than usual) 3
Match and delete rows on two different sheets from reference numbers 4

Top