Results 1 to 14 of 14

Index match issue

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2024
    Location
    paris
    MS-Off Ver
    Windows 365 / version 2302 Build 16.0.16130.20848
    Posts
    12

    Index match issue

    Hi everyone,

    I am trying to reassemble information from different sheet into one, without using multiple pivot tables.
    So I created one Pivot table where I will find the main Animal criteria, and I try to attach the other information with a formula INDEX MATCH.

    The information I am seeking to, is to find for every "Animal criteria" (sheet animal analysis column G) the different "classification of animal" (sheet animal analysis, column O). Warning, their is multiple rows of the same Animal criteria, but with different Animal classification.

    Therefore, in the sheet WORK IN PROGRESS, I wish that my columns:
    -E shows "additional requirement" if it is one of the classification found in the sheet Animal criteria ;
    -F shows "compliance +" if it is one of the classification found in the sheet Animal criteria ;
    -G shows "compliance" if it is one of the classification found in the sheet Animal criteria.

    I know it doesn't work the way I did it, because on the first Animal criteria, I know that it has only Compliance +, the second has the 3, and the last Additional requirement and compliance.

    I hope this is understandable and I thank you in advance!!!!!
    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. INDEX, MATCH and OR ISSUE
    By donp058 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-04-2022, 10:23 AM
  2. Replies: 1
    Last Post: 08-17-2019, 01:11 PM
  3. [SOLVED] Index & Match issue
    By Terry-J in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-03-2017, 12:23 PM
  4. [SOLVED] Index/Match Issue
    By jharvey87 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-22-2017, 10:29 AM
  5. Issue: Only returning 1st match on Index/Match
    By tbr2891 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2014, 11:54 AM
  6. index - match - max - if issue
    By bdrilling33 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-02-2014, 01:58 PM
  7. [SOLVED] Match Issue - Consolidate Columns of Data With Match/Index/etc?
    By excelsior123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2014, 05:14 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