Conditional Formatting Formula not reading 2nd column

[JTL9161]

=NOT(ISERROR(VLOOKUP($D2,$W$39:$X$70,1,FALSE)))

I have this formula in Conditional Formatting. I am looking for it to highlight the matches from W39:X70 but its only reading the data in W39:W70 not in X39:X70

D2 is the first cell in a table that runs from D2 to K70


Thanks,
James

 

[etaf]

seems to be working for me

its only looking up the value in column W
and then highlighting the row - where it finds a matching value

like this

Filter - ETAF - based on date (1).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2
3
4				1
5				3
6				4
7				5
8				6
9				7
10
11
12
13
14
15
16
17
18
19
20	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
21	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
22	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
23	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
24	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
25	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
26	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
27	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
28	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
Sheet2

Cell Formulas
Range	Formula
A20:J28	A20	=NOT(ISERROR(VLOOKUP($D2,$W$39:$X$70,1,FALSE)))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:P11	Expression	=NOT(ISERROR(VLOOKUP($D2,$W$39:$X$70,1,FALSE)))	text	NO

Filter - ETAF - based on date (1).xlsx
	V	W	X	Y
37
38
39		1
40		4
41		7
42
43
44
45
Sheet2

 

[JTL9161]

thank you. I'll give it a try