Forum Discussion

Rick71's avatar
Rick71
Copper Contributor
Nov 25, 2024

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_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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.

    • Rick71's avatar
      Rick71
      Copper Contributor

      That's amazing!!! it works smoothly! Thanks a milliion

Resources