| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH FORMULA WORKS, BUT NEED HAVE BLANK CELL WHER I NOW HAVE #N/A
I AM LOOKING FOR A WAY TO USE THE FORMULA BELOW TO RETURN A BLANK CELL
INSTEAD OF #N/A WHERE NO MATCH IS FOUND. ANY IDEAS?? =INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER,SECONDAR Y,0)-1,COLUMN(CODES))) THIS FORMULA DOES WHAT IT SUPPOSED TO DO EXCEPT WHERE NO MATCH IS FOUND. THANKS, JIM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH FORMULA WORKS, BUT NEED HAVE BLANK CELL WHER I NOW HAVE #N/A
if(isna(INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER,S ECONDARY,0)-1,COLUMN(CODES))),"",INDIRECT(ADDRESS(ROW(CODES)+M ATCH(MASTER,SECONDARY,0)-1,COLUMN(CODES))))
Use if and test for isna() "Stewcrew" wrote: I AM LOOKING FOR A WAY TO USE THE FORMULA BELOW TO RETURN A BLANK CELL INSTEAD OF #N/A WHERE NO MATCH IS FOUND. ANY IDEAS?? =INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER,SECONDAR Y,0)-1,COLUMN(CODES))) THIS FORMULA DOES WHAT IT SUPPOSED TO DO EXCEPT WHERE NO MATCH IS FOUND. THANKS, JIM |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH FORMULA WORKS, BUT NEED HAVE BLANK CELL WHER I NOW HAVE
THANKS JOEL! I JUST HAD TO ADD ONE ) TO THE FIRST GROUP AFTER CODES)))) AND
SHE IS WORKING PERFECT. =IF(ISNA(INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER, SECONDARY,0)-1,COLUMN(CODES))))," ",INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER,SECONDA RY,0)-1,COLUMN(CODES)))) JIM "Joel" wrote: if(isna(INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER,S ECONDARY,0)-1,COLUMN(CODES))),"",INDIRECT(ADDRESS(ROW(CODES)+M ATCH(MASTER,SECONDARY,0)-1,COLUMN(CODES)))) Use if and test for isna() "Stewcrew" wrote: I AM LOOKING FOR A WAY TO USE THE FORMULA BELOW TO RETURN A BLANK CELL INSTEAD OF #N/A WHERE NO MATCH IS FOUND. ANY IDEAS?? =INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER,SECONDAR Y,0)-1,COLUMN(CODES))) THIS FORMULA DOES WHAT IT SUPPOSED TO DO EXCEPT WHERE NO MATCH IS FOUND. THANKS, JIM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula works but formula shows in cell??? | Excel Worksheet Functions | |||
| Index match formula works in for one worksheet reference but not another | Excel Worksheet Functions | |||
| formula works when referring to one cell but not to another | New Users to Excel | |||
| Problem with HLookup - Sometimes works, sometimes blank. | Excel Discussion (Misc queries) | |||
| If Match Part of Text Within Cell, Then Blank | Excel Worksheet Functions | |||
Linear Mode
