Simple subtraction

[elersbuh]

I am trying use a simple subtraction formula on excel referencing values that appear using a vlookup.

As you can see in the image below, you can enter a point number in B36 and B37, the relevant easting and northing for both points will appear in adjacent cells. What I am trying to do is calculate the delta easting/northing between both points. It is a simple subtraction but when whenever I try to input the formula is does not work and I am not too sure why?

 

[elersbuh]

CPPSIS5060 EXCELL Assessment 1 Worksheet.xlsx
	A	B	C	D
35		Point	Easting	Northing
36	FROM	8	566036	6378999
37	TO	9	568634	6377941
38			Delta E	Delta N
39			69
Sheet1

Cell Formulas
Range	Formula
C36:C37	C36	=VLOOKUP(B36,Table2,2,TRUE)
D36:D37	D36	=VLOOKUP(B36,Table2,3,TRUE)
C39	C39	=UNICODE(RIGHT(C38,1))

 

[Alex Blakenburg]

Oops please use C36

 

[Peter_SSs]

I havent changed anything from what you have done

Yes you have - in post #8 you have it in columns L:Q, not B:G like Alex. So your formulas in column Q are referencing cells in columns C:D not M:N. (I don't think that is your underlying problem though)