Tati that could be him because he was married to Mary Reid on 6/11/1824 and so the age is about right.
Just to complicate things I have found an Andrew Smith on the 1841 census.
HO7/824/1 page 22 at Lesbury near Longhoughton on the A1068 road.
Andrew Smith 25 yrs a Miller,William Smith 15 yrs Miller,Margaret Smith 10 yrs,Thomas Smith 40 yrs Farmer.
So could he be the one born 1814 ish? So over to you Anste.
Bill.