+ Reply to Thread
Results 1 to 6 of 6

Finding Matching Data From Multiple Columns in 2 Different Excel Files

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    Spring, TX
    MS-Off Ver
    Excel 2007
    Posts
    9

    Finding Matching Data From Multiple Columns in 2 Different Excel Files

    First of all, I believe I'm in the right forum but if not, please let me know.

    I need to find if there are matching addresses in 2 different excel files. If the same address appears in both files, I would like the new worksheet to return the address along with the sale price from the 1 file and the rental amount from the other file.

    I have tried using vlookup but the problem is the exported data file contains the street number in one column and the street name on another column. I have attached a truncated example of both the rental data and the residential sales data.

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: Finding Matching Data From Multiple Columns in 2 Different Excel Files

    I think I can help you here
    Attached Files Attached Files
    Last edited by mehmetcik; 09-28-2013 at 10:06 AM.

  3. #3
    Registered User
    Join Date
    03-06-2012
    Location
    Spring, TX
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Finding Matching Data From Multiple Columns in 2 Different Excel Files

    Thanks for your help but what I need is for Excel to return only the address or addresses that are found in both files (I probably didn't explain it very well at first). The files can be quite long and it is time consuming to scan through each address to see which can be found in the other file.

    I have an intermediate knowledge of Excel but haven't been able to figure this one out.

    Thanks for your help!

  4. #4
    Registered User
    Join Date
    03-06-2012
    Location
    Spring, TX
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Finding Matching Data From Multiple Columns in 2 Different Excel Files

    Does anyone have an idea of how to solve this? Thanks!

  5. #5
    Registered User
    Join Date
    09-30-2013
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Finding Matching Data From Multiple Columns in 2 Different Excel Files

    Hi!

    in both worksheets, insert a new column A (before the existing A column) with the new address: =D2&" "&C2
    in one of the worksheets, import the numbers you need (sales - if you are in rentals or lease-if you are in sales worksheet), using the vlookup function. you should lookup the data using the newly created columns.

  6. #6
    Registered User
    Join Date
    03-06-2012
    Location
    Spring, TX
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Finding Matching Data From Multiple Columns in 2 Different Excel Files

    So, is there no way to accomplish this without editing the 2 exported data files first? If there isn't, then I will go ahead and attempt your suggestion. However, I was hoping for a way to do this without having to alter the 2 source files.

    Thanks for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Finding matching info across multiple columns & worksheets
    By stacey2013 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2013, 02:18 PM
  2. Finding matching data in long columns of data
    By atltempleman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2012, 03:43 AM
  3. Matching Data with multiple columns
    By Jimboted in forum Excel General
    Replies: 9
    Last Post: 04-01-2011, 01:50 PM
  4. [SOLVED] Matching data in multiple columns
    By BuddyB in forum Excel General
    Replies: 2
    Last Post: 02-27-2005, 05:06 PM
  5. Finding common data in multiple columns and rows in Excel
    By sparham in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2005, 01:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1