I am trying to get his excel formula to work. This is an API to Marketo to do Excel calculations.
The calculation I am trying to do is:
=INDEX({ “Score1″, “Score2″, “Score3″, “Score4″, “Score5″}, MATCH( MAX({ {{lead.Score1:default=0}}, {{lead.Score2:default=0}}, {{lead.Score3:default=0}}, {{lead.Score4:default=0}}, {{lead.Score5:default=0}},{ {{lead.Score1:default=0}}, {{lead.Score2:default=0}}, {{lead.Score3:default=0}}, {{lead.Score4:default=0}}, {{lead.Score5:default=0}} }))
{{lead.Score1:default=0}} will give the value of Score1 from Marketo (eg. 50).
Want this to return “Score1” when Score1 is max, “Score2” when score2 is max and so on.
What am i doing wrong here?
Index Match- What am I doing wrong?
The calculation I am trying to do is:
=INDEX({ “Score1″, “Score2″, “Score3″, “Score4″, “Score5″}, MATCH( MAX({ {{lead.Score1:default=0}}, {{lead.Score2:default=0}}, {{lead.Score3:default=0}}, {{lead.Score4:default=0}}, {{lead.Score5:default=0}},{ {{lead.Score1:default=0}}, {{lead.Score2:default=0}}, {{lead.Score3:default=0}}, {{lead.Score4:default=0}}, {{lead.Score5:default=0}} }))
{{lead.Score1:default=0}} will give the value of Score1 from Marketo (eg. 50).
Want this to return “Score1” when Score1 is max, “Score2” when score2 is max and so on.
What am i doing wrong here?
Index Match- What am I doing wrong?