How can I find comon values in seperate spreadsheets?

B

Bill in Wichita

Can I take the phone numbers from one spreadsheet to find the matching
numbers and the name, address, etc. from a second spreadsheet.
 
K

kraljb

Assuming that the phone numbers are put in the same way (i.e
555-555-1234 vs. (555)555-1234 on the different spreadsheets, you ca
do an INDEX and MATCH formula.

Sheet1 has just the phone numbers (in col A)where you want mor
information
Sheet2 has the addresses (col B) and phone numbers(col A)

in Col B of Sheet 1 right the following
=INDEX(Sheet2!B$1:B$1000,MATCH($A1,Sheet2!$A$1:$A$1000,0),0
 
V

VBA Noob

Say Column A has Phone numbers in Sheet 1 and Sheet 2 has Phone No i
Column A, Name In Column B, Address in Column C then use a vlookup

Name =VLOOKUP($A1,Sheet2!$A$1:$D$13,*2*,FALSE)
Addess =VLOOKUP($A1,Sheet2!$A$1:$D$13,*3*,FALSE)

To change lookup column just change the bol number.

Note you get a #N/A if number not in list

VBA Noo
 
Top