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?
Who is Participating?
CluskittConnect With a Mentor Commented:

EDIT: there was one ) missing
Dixie_electricAuthor Commented:

Close. Close enough I'll take it.


is what worked. ) was in the wrong place
I'm pretty sure Cluskitt meant to post:

It could also be:
Yes, sorry, I got confused by the )
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.