While its true that no activity perfectly mimics or prepares you for another...some are closer than others:
Cycling won't prepare your joints and muscles for long distance running.
BUT...there is no doubt that when I'm in good cycling shape(which includes some sprint intervals and low-cadence climbing intervals)... I can go up 5-6 flights of stairs WAY easier than my non-cycling friends. They are complaining before I'm even noticing that I should slow down. Same for hiking uphill there's no question cycling helps with that.