to just not show th e#NA, one method is to use conditional formating to make
the font color white when an error occurs
<format<conditional formating
formula is =iserror(A1)
format-font-color-white

"BKO" wrote:

Hi, To prevent th nasty #NA in my sheet, I use

=IF(ERROR(MATCH( .... ));"";INDEX( .. ;MATCH( ...))

But now the aclculation time has increesed dramaticaly,

Is there another way to do this

Thanks a lot if anyone could help me with this

--
There are only 10 types of people in the world:
Those who understand binary and those who don't.