OK, quick question, should be fairly easy, but I haven't been able to figure it out.
By design if A2 is found in the column E then it outputs the information in A2. If it not found, then it outputs an empty cell.
What I need is the opposite. If the number matches, output a blank cell, else output the information in A2. I have part of it worked out.
This will output A2 regardless. Now, how do I output a blank cell if the number is found?