+ Reply to Thread
Results 1 to 1 of 1

Index & Match unable place to correct row & display only 1st row for same value

  1. #1
    Forum Contributor
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    262

    Index & Match unable place to correct row & display only 1st row for same value

    Hi All,

    I have a complex lookup where INDEX & MATCH returns only the location but i want are the followings:
    1. to match & returns to the correct row
    2. able to identify the next row should value are same. INDEX & MATCH only point to the 1st row for match numbers when same value are also in the subsequent row.


    what i want to do:
    column F to match with column H & to place in column G

    what im doing now is to manually move value from column K to column G

    column J is INDEX where i could see the location column F & column K is INDEX & MATCH for the value


    Any help is greatly appreciated.

    Thank-You very much
    Attached Files Attached Files
    Last edited by chaiyya345; 09-12-2019 at 10:05 PM. Reason: 2 arguments

+ 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. Need to create one column from many, unable to use index/match
    By awalchp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-15-2019, 10:48 AM
  2. Replies: 3
    Last Post: 01-20-2018, 01:28 AM
  3. unable to get match property error in userform derived index match
    By alexcrofut in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2015, 09:21 PM
  4. Replies: 5
    Last Post: 02-09-2015, 01:54 PM
  5. [SOLVED] Resolved >>> Reverse Lookup (Index & Match)
    By SamuelT in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-21-2014, 05:53 AM
  6. Unable to use MATCH/INDEX to obtain value above and below in a column
    By ryanmc29 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-01-2014, 08:31 AM
  7. vLOOKUP DUPLICATE VALUES; Unable to use index and match
    By CanonG in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-18-2013, 08:45 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