Results 1 to 4 of 4

INDEX MATCH and PIVOT TABLE issue with very long cells

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 and PIVOT TABLE issue with very long cells

    Hello 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 (sheet "Work in progress" ; column C) , and I try to attach the other information with a formula INDEX MATCH.

    The information I am seeking to attach to the "Work in progress" sheet, is to find for every "Animal criteria" (which can be found in both sheets "Work in progress" column C, and sheet "Animal analysis" ; column G) the different "classification of animal" (which is for now only in 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.

    N.B. I left the initial formula in the sheet to help for the INDEX MATCH because the "Animal criteria" is very long and doesn't work with a "simple" index match or vlookup.

    Thanks for your help!
    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. [SOLVED] Issue with matching/linking cells / Index, offset & match functions /
    By Dorobo893 in forum Excel General
    Replies: 7
    Last Post: 08-09-2021, 02:01 AM
  2. Replies: 3
    Last Post: 04-18-2021, 03:58 PM
  3. [SOLVED] Index Match Issue Not Working in all the cells
    By amjad831001 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-18-2019, 08:47 AM
  4. INDEX & MATCH in a Pivot Table
    By charlesfarrell in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-22-2017, 08:44 PM
  5. Replies: 2
    Last Post: 12-18-2014, 09:52 AM
  6. Index and match from a pivot table
    By XLBob in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2009, 07:44 AM
  7. [SOLVED] Index & Match on Pivot Table
    By Nelson in forum Excel General
    Replies: 2
    Last Post: 04-11-2005, 10:06 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