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