How can I find comon values in seperate spreadsheets?

[Guest]

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

 

[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

 

[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