VLOOKUP Problems with formula

  • Thread starter Thread starter treeroot
  • Start date Start date
T

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
 
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
Click to expand...

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".
 
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)

Spiky said:
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
Click to expand...

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".
Click to expand...
 
Try this one

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

=IF(ISNA(MATCH(A1,Sheet2!$A$1:$A$199,0)),"good","bad")
 
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.
 
It looks like this is alot closer to what I need. but it is just returning a
value of good in col B 1.
muddan madhu said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF , match formula problems 1
IF , MATCH problems with formula 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Need VLOOKUP to Work Two Ways 0
VLOOKUP formula 3
Vlookup and return sheet name also 2
VLOOKUP returning formula 3
Not sure whether to use VLOOKUP or an IF statement 2

Back
Top