Here is my formula.
These cells contain text
Cell K3 and Positions!$C$2:$C$2500
If there is no match then the formula returns #N/A. I need it to return 0 instead of #N/A.
I have tried several different combination's but cannot get it to return 0.
{=INDEX(Positions!$F$2:$F$2500,MATCH($J$2&K3,Positions!$A$2:$A$2500&Positions!$C$2:$C$2500,0))}
Any Help would be appreciated.
These cells contain text
Cell K3 and Positions!$C$2:$C$2500
If there is no match then the formula returns #N/A. I need it to return 0 instead of #N/A.
I have tried several different combination's but cannot get it to return 0.
{=INDEX(Positions!$F$2:$F$2500,MATCH($J$2&K3,Positions!$A$2:$A$2500&Positions!$C$2:$C$2500,0))}
Any Help would be appreciated.