Yes. While you won't get a current, real-time location, Find My iPhone (on another device, such as your iPad) will show you your iPhone's last location before its battery died. If your iPhone is offline, you can select Play a Sound to help you locate the device, If the iPhone is dead, select Notify When Found to receive an update on its location when it's turned on again.