If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VLOOKUP Problems with formula
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 |
#2
|
|||
|
|||
VLOOKUP Problems with formula
On Sep 23, 2:33 pm, treeroot
wrote: 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". |
#3
|
|||
|
|||
VLOOKUP Problems with formula
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" wrote: On Sep 23, 2:33 pm, treeroot wrote: 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". |
#4
|
|||
|
|||
VLOOKUP Problems with formula
Try this one
Col B 1 - "High Priority"sheet put this formula =IF(ISNA(MATCH(A1,Sheet2!$A$1:$A$199,0)),"good","b ad") On Sep 23, 3:33*pm, treeroot wrote: 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 |
#5
|
|||
|
|||
VLOOKUP Problems with formula
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. |
#6
|
|||
|
|||
VLOOKUP Problems with formula
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" wrote: Try this one Col B 1 - "High Priority"sheet put this formula =IF(ISNA(MATCH(A1,Sheet2!$A$1:$A$199,0)),"good","b ad") On Sep 23, 3:33 pm, treeroot wrote: 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 |
Thread Tools | |
Display Modes | |
|
|