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
|