Post by Roonyroo » 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
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