I'm pretty sure it's final anyway!
Having taken on board all the advice from the group I decided that before crawling around the loft space I should just check the ceiling rose of the last light before the problem lights (the study light).
Eureka! Two loose screws - one on the live the other on the neutral - with the wire flapping around inside the connecting block. Tightened them both up, put a temporary light in the kitchen in a bayonet connector and voila, I have light!
I do have to re-fit the study light which is a brass chandelier but that just needs patience, I also need to re-fit the chandelier in the lounge but again patience.
Enormous thanks to everybody for the ideas/suggestions, it helped me take a much more logical and systematic approach to the problem - which I think has rubbed off as I managed to get a computer program I am writing working this morning after months of not being able to find the problem.
I think an LED strip light will be best in the kitchen (I don't want the silly spotlights back), what wattage to give me decent light in a 15' x
10' kitchen? As it's a kitchen do I need to get a qualified person to fit it?Thanks again!