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.
|