Run a xsl:choose using the result of a formula
<p>Creating an XSL to translate XML into Excel. Part of that is a formula which performs a lookup on another worksheet. However, I want to transform/translate the return, so I figured an xsl:choose would be best.</p>

<p>But I don't know how to reference my ss:Formula inside the xsl:choose?</p>

<pre><code>    &lt;Cell ss:StyleID="RARs17"
        ss:Formula="=INDEX('{$vhostname}'!R2C6:R{$vuln_count+7}C6,MATCH(RC3,'{$vhostname}'!R2C14:R{$vuln_count+7}C14,0))&gt;
        &lt;Data ss:Type="String"&gt;
        &lt;xsl:choose&gt;
            &lt;xsl:when test="ss:Formula = 'NF'"&gt;Completed&lt;/xsl:when&gt;
            &lt;xsl:when test="ss:Formula = 'NR'"&gt;NR&lt;/xsl:when&gt;
            &lt;xsl:when test="ss:Formula = 'O'"&gt;Ongoing&lt;/xsl:when&gt;
            &lt;xsl:when test="ss:Formula = 'NA'"&gt;NA&lt;/xsl:when&gt;
            &lt;xsl:otherwise&gt;&lt;xsl:value-of select="ss:Formula" /&gt;&lt;/xsl:otherwise&gt;
        &lt;/xsl:choose&gt;&lt;/Data&gt;
    &lt;/Cell&gt; &lt;!-- Status, looks up Result --&gt;
</code></pre>