How can I find comon values in seperate spreadsheets?
 

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

How can I find comon values in seperate spreadsheets?
 

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 can
do an INDEX and MATCH formula.

Sheet1 has just the phone numbers (in col A)where you want more
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)


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=560870

How can I find comon values in seperate spreadsheets?
 

Say Column A has Phone numbers in Sheet 1 and Sheet 2 has Phone No in
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 Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=560870