Convert Errors to Blank Cells in Excel Formula

Discuss other programming languages besides AutoHotkey
Roonyroo
Posts: 36
Joined: 29 Jan 2014, 20:29

Convert Errors to Blank Cells in Excel Formula

18 Jan 2018, 12:42

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

Return to “Other Programming Languages”

Who is online

Users browsing this forum: No registered users and 18 guests