+ Reply to Thread
Results 1 to 2 of 2

Excel match 2 columns return value from 2nd table

  1. #1
    Registered User
    Join Date
    03-06-2017
    Location
    MALAYSIA
    MS-Off Ver
    2016
    Posts
    1

    Excel match 2 columns return value from 2nd table

    i'm trying to match 2 columns from 2 tables,and then in table 1 return the value from table 2,function i use in output(orange color column) column is =IF(A:D,E,""),but not working,any ideas why?

    Capture1.PNG

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Excel match 2 columns return value from 2nd table

    Consider your table ranges as above, put at B2 and copied down as necessary

    =IFERROR(INDEX($E$2:$E$4,MATCH(A2,$D$2:$D$4,0)),"")

+ 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] Need to match two columns and return a third column value from a table
    By HRGIRL16 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2017, 02:18 AM
  2. MATCH two columns to return a corresponding value!
    By cs02 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-18-2015, 07:04 PM
  3. Replies: 9
    Last Post: 12-16-2013, 04:02 AM
  4. Replies: 20
    Last Post: 04-15-2013, 01:06 PM
  5. Replies: 12
    Last Post: 03-29-2013, 03:02 PM
  6. Match Columns in 2 Worksheets, return only changed values of other columns
    By cheynooki in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2011, 01:19 PM
  7. Replies: 5
    Last Post: 10-11-2008, 04:01 PM

Tags for this Thread

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