Results 1 to 5 of 5

Comparing two columns and if there is a match then return values from a different column

Threaded View

  1. #1
    Registered User
    Join Date
    05-25-2017
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    3

    Comparing two columns and if there is a match then return values from a different column

    Hi,

    I have 3 columns.
    Need to check whether col1 value exist in col2 and if it does, then pick up the values from col3 adjacent to col2 and populate the values in col 4 & col 5. For a value in col1, there can be multiple values in col 3(at max 2).

    Capture.PNG

    I have attached an image containing my input and output.


    Please help.
    Last edited by skywalkertinks; 05-25-2017 at 06:38 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. INDEX/MATCH Formula issue-comparing dates in 4 columns to return a value
    By hopegriffin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-06-2016, 05:15 PM
  2. [SOLVED] Help comparing two columns of data with same names different values (index match??)
    By exceldion in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-16-2015, 09:43 AM
  3. Replies: 1
    Last Post: 08-18-2014, 11:10 PM
  4. [SOLVED] Comparing values in two columns and highlighting cells that don't match
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-10-2014, 07:51 AM
  5. Comparing two text columns and return data based on an exact match
    By AShah33 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-04-2013, 04:23 PM
  6. Replies: 1
    Last Post: 01-23-2013, 08:59 PM
  7. Comparing 2 columns- if a match is found return a value in 3rd column
    By lineson in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-20-2011, 04:48 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