In spotlight search, you can hold down cmd to show the path of the selected file. And cmd + enter will open the containing folder in finder.