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!!!!!
Bookmarks