IFERROR, INDEX, MATCH - output help

[cmerrick]

I have a formula that uses an IFERROR, an INDEX and a MATCH formula at once.

I want to change the output value of the MATCH so if a MATCH is found it outputs a 'YES' rather than the value that is being looked for.

Formula is below;

=IFERROR(INDEX('[Management Db 1.1.xlsm]Data'!$C$3:$C$10000,MATCH($A4,'[Management Db 1.1.xlsm]Data'!$E$3:$E$10000,0),MATCH(F$3,'[Management Db 1.1.xlsm]Data'!$C$3:$C$10000,0)),0)

The output is currently set to 'MARCH' and it's basically checking to see if the word MARCH has been written in another document in a certain range. Instead of returning MARCH if it's detected I want it to say 'YES'.

Is it possible with this formula or do I need a new formula?

Thanks

 

[yky]

The easiest way is to wrap your formula with an IF. Try this:

=IF(your formula=0, 0, "yes")