Open up Disk Utility and see if it's listed in the side bar. At least then you'll know if your Mac is even aware something is plugged in.
And based on the wording you used, I assume your friend put stuff on the external drive for you to transfer to your computer? Do not format it otherwise it will delete the files on the external hard drive.