| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If / Match in a IF / Match
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match 2 Columns, Return 3rd, Differing Match Types | Excel Worksheet Functions | |||
| Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Threaded Mode
