Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find exact values of SQRT | Excel Worksheet Functions | |||
Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) | |||
in excel, how do I find which values doesn't have a pair? | Excel Discussion (Misc queries) | |||
To find different values in Col B corresp. to repeated vaues in c | Excel Worksheet Functions |