| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match formula question with isna
I need to match using two columns - this doesnt see to be working: =IF(ISNA(MATCH(I11&J11,'Projected MCE Report Northern C'!I:I &'Projected MCE Report Northern C'!J:J,0)),"",INDEX('Projected MCE Report Northern C'!U:U,MATCH(I11&J11,'Projected MCE Report Northern C'!I:I &'Projected MCE Report Northern C'!J:J,0),1,0)) wondering what i have done wrong: If the data in I 11 and J 11 match my second report column i and J then i want to get the data in colum U. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match with isna formula question | Excel Worksheet Functions | |||
| ISNA match function help | Excel Worksheet Functions | |||
| If isna match vlookup formula | Excel Worksheet Functions | |||
| IsNA(match | Excel Worksheet Functions | |||
| IsNA(match | Excel Worksheet Functions | |||
Threaded Mode
