+ Reply to Thread
Results 1 to 6 of 6

Find matching criteria in column and use data from other cell in row

  1. #1
    Forum Contributor
    Join Date
    10-29-2004
    Posts
    291

    Question Find matching criteria in column and use data from other cell in row

    I have two work sheets I'm using.

    Sheet1!A column contains a list of customer names like "Smith, John".

    Sheet2!A contains the same list of name with additional information found in the row. For example, you will find "Smith, John" in Sheet2!A3 and John's phone number in Sheet2!B3

    In Sheet1!B it to find the associated telephone number based on matching criteria from Sheet1!A and Sheet2!A

    For example, Sheet2 has the following data.

    Please Login or Register  to view this content.
    On Sheet1 I have the following names. You'll notice some of the names repeat.

    Please Login or Register  to view this content.
    In column Sheet1!B I would like it to scan column A from sheet2 and display the data show in column B. So it would look like this-

    Please Login or Register  to view this content.
    You'll notice some names repeat but it always displays the correct number from Sheet2.

    How would I accomplish this?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Find matching criteria in column and use data from other cell in row

    Take a look at using the VLOOKUP() function
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Find matching criteria in column and use data from other cell in row

    may be this......

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Forum Contributor
    Join Date
    10-29-2004
    Posts
    291

    Re: Find matching criteria in column and use data from other cell in row

    Thanks but I don't quiet understand what the $B$9 in the range is for.

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Find matching criteria in column and use data from other cell in row

    in =VLOOKUP(A2,Sheet2!$A$2:$B$9,2,FALSE), Sheet2!$A$2:$B$9 is a table array where $A$2 (or A2) is the first cell in the first column of the table array and $B$9 is the last cell in the last column of the table array.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Find matching criteria in column and use data from other cell in row

    vlookup syntax is...
    =VLOOKUP(what-you-want-to-find,range-to-search-in,column-that-contains-the-match,FALSE) FALSE is for finding an exact match

+ 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. How to find matching values in two column of data
    By medialiver in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2013, 09:59 AM
  2. Cell sum based on matching column criteria
    By djarcadian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2013, 05:40 PM
  3. [SOLVED] find matching data from one cell in different column
    By chouston in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2013, 05:10 PM
  4. Replies: 6
    Last Post: 07-10-2011, 05:10 PM
  5. Average a cell in a column if matching a set of criteria
    By Kosherboychief in forum Excel General
    Replies: 9
    Last Post: 05-31-2011, 12:17 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