Different printers have CMYK primaries with different spectra, so there’s not going to be a generic solution. But in principle, CMY can only create a linear combination of three discrete frequency bands, not a continuous spectrum.
The same will be true of the appearance under monochromatic light: you can only make colors that blend the monochromatic appearance of the primaries. So if none of the three primaries has the desired effect, you can’t create the effect by mixing them.