+ Reply to Thread
Results 1 to 2 of 2

How to find unique identifier and add data to cell

  1. #1
    Registered User
    Join Date
    09-20-2011
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    5

    How to find unique identifier and add data to cell

    Hi,

    I have two spreadsheets that I'm looking to merge into one. Spreadsheet one has one column with a unique identifying key (example: 0099A). Column 2 has an owner name (Bob Smith). This is how it would look:

    0099A | Bob Smith

    Spreadsheet two is a list of properties. Column one has an identifying key that corresponds with the keys in spreadsheet one. The second column is a property address. Following the example above, one line of the spreadsheet would be:

    0099A | 700 North Avenue

    As you can imagine, there are many people who own multiple properties so the number of rows in spreadsheet one and two are not equal. What I'd like to do is have the unique key (column A)| address (column B) | owner name (column C) all on one spreadsheet.

    From spreadsheet 2, what formula would I use to run through all of the identifying keys and add the corresponding owner name? I'm assuming I would have to copy paste the data from spreadsheet one into spreadsheet two.

    BTW: I have excel 2013 if it matters.

    Thanks!

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: How to find unique identifier and add data to cell

    Try this formula in your sheet 2 to get the owner name in column C:
    Please Login or Register  to view this content.
    You'll have to change the range Sheet1!$A$1:$B$5 to specify the sheet name and actual range of data in sheet 1.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ 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. Merging data using unique column identifier?
    By jjinca in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 05-14-2013, 07:55 AM
  2. Adding Unique Identifier to Rows of data
    By adam_w2009 in forum Excel General
    Replies: 13
    Last Post: 04-21-2013, 06:37 AM
  3. Macro to move data from one cell to another where unique identifier changes
    By boothyuk123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2012, 05:36 PM
  4. Combine rows of data into 1 cell based on unique identifier
    By jud_goh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-11-2010, 05:06 PM
  5. Combine Unique data for Same Identifier
    By Excel Noobie in forum Excel General
    Replies: 4
    Last Post: 10-12-2006, 08:14 PM

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