Gearbox question - 2014 MC Diesel

[Prai]

A friend who also has a Mondeo was driving and his car went into limp mode and wouldn't put any power down. When he restarted it worked fine but he was suspecting it was the gearbox and took it to his local Ford dealer. They had a brief look without pulling it all apart and have said he needs a new gearbox and it isn't worth doing considering the value of the car. He has driven it 190,000 which isn't that much in my opinion and I was wondering if anyone had advice on either a second opinion or the cost of sourcing a reconditioned gearbox?