VLOOKUP Problems with formula

[treeroot]

I have a workbook on the first sheet is my "high priority" my email column is
A4:A5764 and on sheet 2 I have a list of bad emails A1:A1199 that need to be
taken off my "high priority" on sheet 1. I have something like this.
=VLOOKUP(A1,'[Sheet2]High Priority'!A$1:A$5764,2,FALSE)

it isn't working......help

 

[Spiky]

I have a workbook on the first sheet is my "high priority" my email column is
A4:A5764 and on sheet 2 I have a list of bad emails A1:A1199 that need to be
taken off my "high priority" on sheet 1. I have something like this.
=VLOOKUP(A1,'[Sheet2]High Priority'!A$1:A$5764,2,FALSE)

it isn't working......help

What is in Column B on Sheet2? And did you type that formula here or
copy it from the workbook? Because it looks like the sheet reference
is bad, unless your file is really named "Sheet2".

 

[treeroot]

Ok Sheet 2 is my bounce back emails (the bad emails) Column B is empty of
Bounceback sheet. I have emptied column B of my high priority sheet too to
give me a place to bring back the value. I have no clue...
=VLOOKUP(bouncebacks!A1:A1199,A3:A5763,2,FALSE)

I have a workbook on the first sheet is my "high priority" my email column is
A4:A5764 and on sheet 2 I have a list of bad emails A1:A1199 that need to be
taken off my "high priority" on sheet 1. I have something like this.
=VLOOKUP(A1,'[Sheet2]High Priority'!A$1:A$5764,2,FALSE)

it isn't working......help

What is in Column B on Sheet2? And did you type that formula here or
copy it from the workbook? Because it looks like the sheet reference
is bad, unless your file is really named "Sheet2".

 

[muddan madhu]

Try this one

Col B 1 - "High Priority"sheet put this formula

=IF(ISNA(MATCH(A1,Sheet2!$A$1:$A$199,0)),"good","bad")

 

[Spiky]

Well, neither of those VLOOKUPs were set up properly. And they looked
to that 2nd column, so even if it found a match, it would return a
blank from your empty column.

But vlookup isn't really what you want anyway. I think muddan's
formula should help. Then you can Sort on column B and easily delete
all the Bad lines. If that is what you are trying to do.

 

[treeroot]

It looks like this is alot closer to what I need. but it is just returning a
value of good in col B 1.

Try this one

Col B 1 - "High Priority"sheet put this formula

=IF(ISNA(MATCH(A1,Sheet2!$A$1:$A$199,0)),"good","bad")

I have a workbook on the first sheet is my "high priority" my email column is
A4:A5764 and on sheet 2 I have a list of bad emails A1:A1199 that need to be
taken off my "high priority" on sheet 1. I have something like this.
=VLOOKUP(A1,'[Sheet2]High Priority'!A$1:A$5764,2,FALSE)

it isn't working......help