Vlookup

OK, quick question, should be fairly easy, but I haven't been able to figure it out.

=IFERROR(VLOOKUP(A2,E:E,1,FALSE),"")

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.

=IFERROR(VLOOKUP(A2,E:E,1,FALSE),A2)

This will output A2 regardless. Now, how do I output a blank cell if the number is found?
Dixie_electricAsked:
Who is Participating?
 
CluskittCommented:
=IF(ISERROR(VLOOKUP(A2,E:E,1,FALSE),A2,""))

EDIT: there was one ) missing
0
 
Dixie_electricAuthor Commented:
=IF(ISERROR(VLOOKUP(A2,E:E,1,FALSE),A2,""))

Close. Close enough I'll take it.

=IF(ISERROR(VLOOKUP(A2,E:E,1,FALSE)),A2,"")

is what worked. ) was in the wrong place
0
 
byundtCommented:
I'm pretty sure Cluskitt meant to post:
=IF(ISERROR(VLOOKUP(A2,E:E,1,FALSE)),A2,"")

It could also be:
=IF(ISNA(MATCH(A2,E:E,0)),A2,"")
0
 
CluskittCommented:
Yes, sorry, I got confused by the )
0
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.