Page 1 of 1

Convert Errors to Blank Cells in Excel Formula

Posted: 18 Jan 2018, 12:42
by Roonyroo
Found a formula off the net, the formula works great, but I cant figure out how to get rid of errors, ie n/a, in excel.

I've tried isna, & iferror, but cant work out the syntax.

It would also be great if the errors converted to 0 using isna or iferror, were turned to blank cells.

The Excel formula =INDEX($J$1:$J$290,MATCH(N1,$I$1:$I$290,0))

I cell
Basic/Attention Token 1 
Basic Attention Token 3 
Basic Attention Token 2 
Basic Attention Token 1 

N Cell

Basic/Attention Token 1 
Basic Attention Token 2 
Basic Attention Token 1 

J Cell

56
34
23


Thanks