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

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

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