If a room has more than one exit, how do I specify which sound should be played depending upon what exit is chosen. Ex. One exit is through a creaky door, the other bis down a staircase.

You can attach a script to an exit. Use that to play your sound.
Just remember that the script will also have to move the player through the door; probably using the line player.parent = this.to