+ Reply to Thread
Results 1 to 5 of 5

How to return value in third column if values in first two columns are matching?

  1. #1
    Registered User
    Join Date
    07-17-2013
    Location
    Hyderabad, India
    MS-Off Ver
    office 365
    Posts
    51

    How to return value in third column if values in first two columns are matching?

    Hello Experts,

    Need your help.

    I have a two different workbooks book 1 and book 2 with some data.

    If values of first two columns ( Column A and B) of both workbooks are matching then I want a formula that can return the value of third column (column c) of book 2 in book 1 column c.

    example:

    Book 1

    column A / Column B / Column C

    100 / 200 /

    Book 2

    Column A / Column B / Column C

    100 / 200 / 300

    now I want a formula that can return in column C of book 1 to display 300.

    And the data runs across some 100 rows in both workbooks.

    Please help.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: How to return value in third column if values in first two columns are matching?

    Would the match be anywhere in the rows or the same row (i.e. Book1A2 and B2 = Book2 A2 and B2 OR Book1A2 and B2 matches Book 2 A145 and B145)?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    07-17-2013
    Location
    Hyderabad, India
    MS-Off Ver
    office 365
    Posts
    51

    Re: How to return value in third column if values in first two columns are matching?

    match the same row.

  4. #4
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: How to return value in third column if values in first two columns are matching?

    Book one column c - c2 cell =
    =Sumifs(Book2ColumnC, Book2Columna, Book1A2, Book2ColumnB, Book1B2)

    You can use this formula if the values there are unique. Otherwise you should use index match
    Appreciate the help? CLICK *

  5. #5
    Registered User
    Join Date
    07-17-2013
    Location
    Hyderabad, India
    MS-Off Ver
    office 365
    Posts
    51

    Re: How to return value in third column if values in first two columns are matching?

    Thank you, AZ-XL for your formula. worked perfectly if column C has numeric values.

    Need help if column C contains text. (for example: name of a country or any persons name).

+ 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. Replies: 3
    Last Post: 03-14-2014, 06:46 PM
  2. Replies: 0
    Last Post: 10-07-2013, 10:24 AM
  3. matching values based on criteria and return values from another columns
    By lizard54 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 11:29 AM
  4. Replies: 3
    Last Post: 11-24-2011, 09:55 AM
  5. Replies: 3
    Last Post: 11-24-2011, 07:21 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