Forum Discussion
Help with cross-cecking text values in a matrix
Hi There!
i'd immensely appreciate some help from experts out there as i'm getting crazy trying working on a thing with my MacOS Excel
I have the following matrix:
I’m trying to create a formula to fetch the "TalentProfile" cell texts (High, Some, At) and cross-check them against the "Performance" text values (NotMeet, Meet, Outstanding) The central part of the table above shows what the cross-check should return:
As example of the workflow behind it, there you go:
- If the TalentProfile text is "High" AND the Performance text is "Outstanding", then the text to be included in the result cell should be "TopTalent"
- if the TalentProfile is High AND the Performance is NotMeet, then the text to be included in the result cell should be "PotentialTalent"
- If the TalentProfile is "Some" AND the Performance is "Meet", then the text to be included in the result cell should be "KeyTalent"
- Etc..etc.....going so on fetching all the "Talent Profile" values and cross-checking with each "Performance" value, filling in the matrix or another table at choice
I’ve already found a couple of tutorials here, making use of INDEX and MATCH but for some reasons they didn’t work on my make as it stopped processing the formula immediately as I entered it
Hope you can spend some of your valuable time to help me on that
Thanks!
Since you have already mapped the Talent/Performance matrix, you can indeed use INDEX/MATCH to fetch the correct profile from the matrix.
You'll find a simplified example in the attached file.
- Riny_van_EekelenPlatinum Contributor
Since you have already mapped the Talent/Performance matrix, you can indeed use INDEX/MATCH to fetch the correct profile from the matrix.
You'll find a simplified example in the attached file.
- Rick71Copper Contributor
That's amazing!!! it works smoothly! Thanks a milliion