Dixie_electric
asked on
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?
=IFERROR(VLOOKUP(A2,E:E,1,
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,
This will output A2 regardless. Now, how do I output a blank cell if the number is found?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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,"")
=IF(ISERROR(VLOOKUP(A2,E:E
It could also be:
=IF(ISNA(MATCH(A2,E:E,0)),
Yes, sorry, I got confused by the )
ASKER
Close. Close enough I'll take it.
=IF(ISERROR(VLOOKUP(A2,E:E
is what worked. ) was in the wrong place