I am having an issue with a formula for google sheets:
=ifna(IF($A14="TRP Drills",INDEX('Drills DD Skill by Skill'!$B$3:$B,match($D14,'Drills DD Skill by Skill'!$A$3:$A,0))$F14," "),if($A14="DMT Drills",INDEX('DMT Drills DD Skill by Skill'!$B$3:$B,match($D14,'DMT Drills DD Skill by Skill'!$A3:$A,0))$F14,""))
This is working for the first If rule “TRP Drills” but it isn’t working when I change A14 to the second If rule “DMT Drills”
Can anyone see any reasons why this may be not working ?
Thanks in advance
Aucun commentaire:
Enregistrer un commentaire