Vlookup not working

[jrisebo]

Any idea why when M26 is 7.5, my vlookup doenst work?

Book2
	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
25		Lower Angle:		Upper Angle:		Diff
26		0		7.5
27	Zone 1:	1.2	-1.1	2.6	-2.3	1.4	-1.2
28	Zone 2:	1.2	-1.1	2.6	-2.3	1.4	-1.2
29	Zone 3:	1.2	-1.1	2.6	-2.3	1.4	-1.2
30
31
32
33
34
35
36
37
38
39
40
41
42											Clear Wind Flow
43										yes	Zone 3		Zone 2		Zone 1
44								0no	0	no	2.4	-3.3	1.8	-1.7	1.2	-1.1
45								0no	0	no	1.8	-1.7	1.8	-1.7	1.2	-1.1
46								0yes	0	yes	1.2	-1.1	1.2	-1.1	1.2	-1.1
47								7.5no	7.5	no	3.2	-4.2	2.4	-2.1	1.6	-1.4
48								7.5no	7.5	no	2.4	-2.1	2.4	-2.1	1.6	-1.4
49								7.5yes	7.5	yes	1.6	-1.4	1.6	-1.4	1.6	-1.4
50								15no	15	no	3.6	-3.8	2.7	-2.9	1.8	-1.9
51								15no	15	no	2.7	-2.9	2.7	-2.9	1.8	-1.9
52								15yes	15	yes	1.8	-1.9	1.8	-1.9	1.8	-1.9
53								30no	30	no	5.2	-5	3.9	-3.8	2.6	-2.5
54								30no	30	no	3.9	-3.8	3.9	-3.8	2.6	-2.5
55								30yes	30	yes	2.6	-2.5	2.6	-2.5	2.6	-2.5
56								45no	45	no	5.2	-4.6	3.9	-3.5	2.6	-2.3
57								45no	45	no	3.9	-3.5	3.9	-3.5	2.6	-2.3
58								45yes	45	yes	2.6	-2.3	2.6	-2.3	2.6	-2.3
Sheet2

Cell Formulas
Range	Formula
K27	K27	=VLOOKUP(K26&$S$43,$Q$44:Y58,8)
L27,N27	L27	=VLOOKUP(K26&$S$43,$Q$44:Y58,9)
M27	M27	=VLOOKUP(M26&$S$43,$Q$44:Y58,8)
O27:P29	O27	=M27-K27
K28,M28	K28	=VLOOKUP(K26&$S$43,$Q$44:Y58,6)
L28,N28	L28	=VLOOKUP(K26&$S$43,$Q$44:Y58,7)
K29,M29	K29	=VLOOKUP(K26&$S$43,$Q$44:Y58,4)
L29,N29	L29	=VLOOKUP(K26&$S$43,$Q$44:Y58,5)
Q44:Q58	Q44	=CONCATENATE(R44&S44)

 

[jrisebo]

I posted this wrong, not in my reply. See my other post.

 

[AhoyNC]

You need to change the last option in your VLOOKUP's to 0 or FALSE for exact match.

VLOOKUP(M26&$S$43,$Q$44:Y58,8,0)

 

[jrisebo]

Thanks, thats It!