Vlookup issue .

[Sunline]

Hello all , im having a problem trying to get my Vlookup function to acknowledge all data in cols EJ and EK .

As per sample sheet o zeros are being found . But anything else isnt . ???? .
Seems i have a problem with my decimals somewhere , have tried changing formats etc to no avail .
Any help appreciated .
Thanks .

Excel Workbook
	DW	DX	DY	EJ	EK	EL	EM
1	Marg3	Marg2	Marg1	M3/M2	M2/M1	ResultcolEJ	ResultcolEK
2				0.0	0.0	0	0
3	5.6	26.0	6.7	-20.4	19.3	#N/A	#N/A
4				0.0	0.0	0	0
5				0.0	0.0	0	0
6	5.9	1.0	10.9	4.9	-9.9	#N/A	#N/A
7	6.2	4.8	1.8	1.4	3.0	#N/A	#N/A
8				0.0	0.0	0	0
9		4.0	20.9	-4.0	-16.9	#N/A	#N/A
10	10.9	6.3	27.0	4.6	-20.7	#N/A	#N/A
Sheet1

 

[Sunline]

Hello Robert ,
I did Ctrl shift enter the formular , Im going to take 5 on this and do some more research on it .
Also just tried sending you a private message and got this reply .

"Robert Mika has exceeded their stored private messages quota and cannot accept further messages until they clear some space."
Thanks and will return .