Solved

# Vlookup

Posted on 2013-06-20
529 Views
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?
0
Question by:Dixie_electric
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 18

Accepted Solution

Cluskitt earned 300 total points
ID: 39263141
=IF(ISERROR(VLOOKUP(A2,E:E,1,FALSE),A2,""))

EDIT: there was one ) missing
0

Author Comment

ID: 39263264
=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

LVL 81

Expert Comment

ID: 39263284
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

LVL 18

Expert Comment

ID: 39263293
Yes, sorry, I got confused by the )
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!