Quote:
Originally Posted by Mazzaropi
--------------------------------------------------------------------
Dear Cosacoruso, Good Morning.
As you didnīt mentioned the message error, is a little more dificult to think about it.
1)Your formula present this format:
=IF(MATCH(D2,'[WITNESS Renewal YTD (UNTIL FY09) .xls]September 2009'!$K:$K,0)0,"SEP 09",
..IF(MATCH(D2,'[WITNESS Renewal YTD (UNTIL FY09) .xls]August Renewal 2009'!$K:$K,0)0,"AUG 09",FALSE))
Are correct
September 2009'!
AND
August Renewal 2009'!
Names?
2) Argument
If your intention is to show the word FALSE on the second part you need to put it between quotes.
"FALSE" instead of FALSE only.
Does any of my comments above make sense for you?
|
Hi! Thanks for replying.
The problem is that the formula doesn't work and I donīt know why.
It makes sense how is written.
September 2009 and August 2009 are the names of the tabs.
When I put the formula the false part doesn't run the second IF.
The final false is the default one.
I also tried in a new file using new names I wrote (not the default ones in the file, in case there's a problem with the names) but the same error the #N/A and I checked an the value is there in the second tab.
Thanks
best regards