Results 1 to 16 of 16

INDEX MATCH picking up wrong/duplicate value when using with excel table? MS Office 2021

Threaded View

greatinfoteam INDEX MATCH picking up... 05-15-2023, 05:11 AM
AliGW Re: INDEX MATCH picking up... 05-15-2023, 05:16 AM
greatinfoteam Re: INDEX MATCH picking up... 05-15-2023, 06:01 AM
AliGW Re: INDEX MATCH picking up... 05-15-2023, 05:21 AM
greatinfoteam Re: INDEX MATCH picking up... 05-15-2023, 06:05 AM
AliGW Re: INDEX MATCH picking up... 05-15-2023, 06:02 AM
AliGW Re: INDEX MATCH picking up... 05-15-2023, 06:05 AM
greatinfoteam Re: INDEX MATCH picking up... 05-15-2023, 06:40 AM
AliGW Re: INDEX MATCH picking up... 05-15-2023, 07:14 AM
greatinfoteam Re: INDEX MATCH picking up... 05-15-2023, 07:40 AM
tanasedn Re: INDEX MATCH picking up... 05-15-2023, 07:33 AM
greatinfoteam Re: INDEX MATCH picking up... 05-15-2023, 08:38 AM
AliGW Re: INDEX MATCH picking up... 05-15-2023, 07:55 AM
greatinfoteam Re: INDEX MATCH picking up... 05-15-2023, 08:40 AM
AliGW Re: INDEX MATCH picking up... 05-15-2023, 08:40 AM
AliGW Re: INDEX MATCH picking up... 05-15-2023, 08:41 AM
  1. 05-15-2023, 05:11 AM #1
    greatinfoteam is offline
    Registered User
    Join Date
    03-21-2020
    Location
    Lahore, Pakistan.
    MS-Off Ver
    Microsoft Office 2021
    Posts
    30

    INDEX MATCH picking up wrong/duplicate value when using with excel table? MS Office 2021

    Hi,
    Hope everyone is fine there. I am using Microsoft Office 2021 LTSC v2108 Build 14332.20481. I have only two sheets only everything is working fine but sometimes INDEX MATCH picking up wrong/duplicate values it using with excel table? Why?
    But when we do it manually formulation i mean without excel excel table it works fine. Why? Attached file is easily understandable please cooperate with me in this matter. I also concern/post the same problem on Microsoft Tech community.

    Thanks
    Attached Files Attached Files
    Last edited by greatinfoteam; 05-15-2023 at 05:14 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trouble installing Office 2021 Professional Plus
    By cullism in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-02-2022, 05:25 AM
  2. Index/Match not working is Excel Office 365?
    By S Thibault in forum Excel Formulas & Functions
    Replies: 50
    Last Post: 10-04-2020, 05:53 PM
  3. [SOLVED] Index,Match,CountIF Formula NOT working for removing duplicate rows frm Table- plz, Check?
    By sumans054 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2019, 11:28 PM
  4. How to get index match to pick the next available, it keeps picking the same person.
    By vs27739 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2018, 02:25 PM
  5. Index/Match not picking up with nth instances in list
    By Ebo12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-25-2016, 02:45 PM
  6. INDEX(MATCH()) between Excel Table and Duplicate of Excel Table
    By ExcelBin in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-28-2015, 05:16 AM
  7. [SOLVED] Index + Match + IF - Function - Wonder why Excel Kept Refer to The Wrong Want
    By cychua in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 06-29-2014, 06:32 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1