Similar to Paulies post.....
I checked out a train from Cologne on day of the game or day before and it was 3hrs 55m journey direct and between 25-35 euros (special pay in advance fare). I am working in Cologne on the Tuesday.
I think you can get decent cheap flights to Cologne form Ireland/UK or if not try Dussledorf and the train from there.
A bit of hassle but definitely a cheap way of doing it if time is not at a premium.
In the end I booked return from Mcr as it was a similar price but one night less away (Brownies Points with her indoors)
Bookmarks