You could have loose connection at light this could live or neutral, may not be the light that is off, but a light near to it as that light may be suppling live and neutral to faulty one and connection loose at that point
Or the switch may need replacing, if you have tester you can test for continuity across switch to rule that out.
It sounds like to me you have a broken neutral connection on the light that is not working or perhaps a loose switch wire connection an the light fitting.I would recommend you isolate the lighting circuit and then open the light fitting up and check for loose or broken connections
DIY how to tutorial projects and guides - Did you know we have a DIY Projects section? Well, if no, then we certainly do! Within this area of our site have literally hundreds of how-to guides and tutorials that cover a huge range of home improvement tasks. Each page also comes with pictures and a video to make completing those jobs even easier!