Quote:
Originally Posted by Cosacoruso
Hi everyone.
I'm trying to do an if/match and in the false part I want the formula to re run an if/match.
The objective is to search for a value in other workbook in several tabs and bring me a name of the tab where the value is.
The example:
=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))
The first parts works fine, but I don't know why the second if/match doesn't work.
Does anyone knows why or other solution?
Thanks
|
--------------------------------------------------------------------
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?