in it vs up the creek

in it

prep
  • In trouble. 

  • Taking part in something, such as a lottery. 

  • Having an expected payout or reward. 

  • Getting on successfully, especially in a game. 

up the creek

prep
  • In trouble; in a difficult situation. 

How often have the words in it and up the creek occurred in a corpus of books? (source: Google Ngram Viewer )