Results 1 to 5 of 5

Compare Non Exact value from 2column and copy value

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2019
    Location
    Malaysia
    MS-Off Ver
    0365
    Posts
    2

    Compare Non Exact value from 2column and copy value

    Hi All

    I need help. How should i compare value from 2 column and copy value from another column to new column.

    For example.
    excel forum.PNG


    Okay so now, i need to compare value between Column A and Column D. If the ID match, i will need to copy value from Column B to Coumn E.

    I tried to use =INDEX(B2:B5,MATCH(D2,A2:A5,1)) but i receive #N/A

    Kindly advice
    Last edited by Noren Tumaisuri; 02-07-2019 at 06:55 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exact Date and Time compare within a range of exact date and times Lookup and Flag
    By john2001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2015, 06:01 PM
  2. Using EXACT to compare text.
    By ExcelM9 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 07-09-2015, 06:14 AM
  3. [SOLVED] split 1cell that is consist of date and time to 2column
    By sr_88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-28-2013, 05:46 AM
  4. Compare list for Exact Match
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2013, 01:59 PM
  5. [SOLVED] Compare Two Columns (Exact and Wildcard)
    By Xavier in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-15-2006, 01:35 PM
  6. Best compare technique, exact, vlookup? What do I need?
    By firestart in forum Excel General
    Replies: 10
    Last Post: 05-10-2005, 10:04 AM
  7. Best compare technique, exact, vlookup? What do I need?
    By firestart in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2005, 08:59 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