MATCH FORMULA WORKS, BUT NEED HAVE BLANK CELL WHER I NOW HAVE #N/A

S

Stewcrew

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,SECONDARY,0)-1,COLUMN(CODES)))

THIS FORMULA DOES WHAT IT SUPPOSED TO DO EXCEPT WHERE NO MATCH IS FOUND.

THANKS,

JIM
 
J

Joel

if(isna(INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER,SECONDARY,0)-1,COLUMN(CODES))),"",INDIRECT(ADDRESS(ROW(CODES)+MATCH(MASTER,SECONDARY,0)-1,COLUMN(CODES))))


Use if and test for isna()
 
S

Stewcrew

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,SECONDARY,0)-1,COLUMN(CODES))))


JIM
 
Top