+ Reply to Thread
Results 1 to 4 of 4

If a value in 2 different columns match, it returns the value from the next column

  1. #1
    Registered User
    Join Date
    10-25-2018
    Location
    Manchester, England
    MS-Off Ver
    Excel 2016
    Posts
    38

    If a value in 2 different columns match, it returns the value from the next column

    Hi,

    I need a formula that will check the value in A2 (sheet1) and then if that value matches with a value in column A (sheet2) it will return the value from Column B (Sheet 2) in the next cell in Column H (Sheet 1).

    I have tried myself, but not been able to get it to work, any help would be greatly appreciated.

    Regards
    Tom
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,438

    Re: If a value in 2 different columns match, it returns the value from the next column

    How about
    =INDEX(Sheet2!$B$2:$B$600,MATCH(A2,Sheet2!$A$2:$A$600,0))

  3. #3
    Registered User
    Join Date
    10-25-2018
    Location
    Manchester, England
    MS-Off Ver
    Excel 2016
    Posts
    38

    Re: If a value in 2 different columns match, it returns the value from the next column

    Perfect!

    Thanks Fluff13

    Regards
    Tom

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,438

    Re: If a value in 2 different columns match, it returns the value from the next column

    You're welcome & thanks for the feedback.

+ 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] MATCH across multiple columns returns value from LOOKUP table
    By RoundaboutCJP in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-20-2019, 05:52 AM
  2. Replies: 1
    Last Post: 04-26-2017, 09:08 AM
  3. Replies: 4
    Last Post: 04-14-2017, 07:47 PM
  4. [SOLVED] Partial Match in a column that returns the cells to the right.
    By lamenters in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-29-2014, 11:38 AM
  5. Replies: 3
    Last Post: 06-07-2013, 02:28 PM
  6. Replies: 6
    Last Post: 12-10-2012, 06:26 PM
  7. [SOLVED] UDF Match functions that returns ROW and COLUMN position
    By CrispinB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2012, 12:44 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