Right folks I’m stumbled.

my front ceiling lights don’t come on when I turn them in via switch or on button. 
the 2 red lights are on though! And the rear ones work.

ive tried a replacement unit in- same issue.

brand new bulbs-same issue.

 

Any help?

You thought you were driving a car, but it is, in fact, a boat.  Misbehaving lights is one symptom of water ingress damage.  Either current or previously repaired (perhaps a repair coming to the end of its life).  

 

Check through the big thread on the subject.

'Water Ingress Problem'........SOLVED! - Skoda Superb Mk I - BRISKODA

+1 for jimbof's call read this from start to finish my money is on corrosion in the wiring, convenience module soaked in water under the carpet