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
|