View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BKO BKO is offline
external usenet poster
 
Posts: 15
Default Error suppressing with INDEX/MATCH

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.