Results 1 to 3 of 3

Show last matching Data with INDEX MATCH or VLOOKUP

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    118

    Lightbulb Show last matching Data with INDEX MATCH or VLOOKUP

    Hi Guys,

    Can you help me with my problem, I got an error in my IF formula.
    Its quite simple, but I had no idea where it's wrong.

    I already Attach my example,

    Tq in advance

    I use this code, but it just whow the first data that match, and I want to show the Last data that match in row.

    =INDEX('GA01'!$E$5:$E$334;MATCH("*GANTI NET*";'GA01'!$U$5:$U$335;0))
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup with 2 matching criteria -- Index/Match Possibly?
    By dcoughl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2021, 12:38 PM
  2. [SOLVED] Using VLOOKUP || Index/MATCH to return a cell value of a matching value in an array
    By LuckyDay in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2020, 04:20 PM
  3. [SOLVED] Matching data from 2 columns VLOOKUP or INDEX:MATCH
    By Crawfy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2018, 08:18 PM
  4. [SOLVED] INDEX-MATCH or VLookup for pulling in matching data?
    By alexx579 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2016, 01:45 AM
  5. INDEX-MATCH or VLookup for pulling in matching data?
    By alexx579 in forum Excel General
    Replies: 4
    Last Post: 04-25-2016, 09:24 PM
  6. Vlookup or Index/Match only matching the first 8 characters.
    By CCPopsicle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-18-2014, 10:20 AM
  7. Replies: 13
    Last Post: 12-13-2012, 11:44 AM

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