How if and search function together put values false as 0 or blank instead of #value! in cell.

[pankajgrover]

Hi, I am a very normal home basic user . Looking for 1 little help . Here attached excel, In Worksheet Test, R4 displaying #value! how can i calculate if result is false, then put a value like 0 or blank instead of #value!.
Actually I am trying to matching name with cell name , if exists i want some value divide some cells otherwise if not match name, result should be zero or blank.
Please help me with the formula. Thanks

 

[pankajgrover]

As this is a totally different question it needs a new thread. Thanks

okay, i already posted as new thread.