The first question: did your friend format it as NTFS or FAT32. Both should be visible on your Mac, but it can't write to or repair NTFS. If you tried that, it's quite well possible it's corrupted.
And you forgot to tell why he formatted it. Most external hard drive already are formatted.
I could tell you about partition utilities and Disk Management in Windows, but better go back to your friend. He's the expert. He can have a look and tell you if the drive is OK, if it can be fixed and if your data is still there.
If your friend formatted it, there's no data on it. So you lost nothing. Ain't that nice? But maybe you didn't tell the whole story, and he did more than formatting, but copied some data to it. The worst that can happen is that he must do that again, either to the same disk (if fixed) or to another one (if unfixable).
Hello.
My friend formatted my external SEAGATE drive and everything was fine on his PC and laptop. Now I tried to plug it in (I have a MacBook) and it wasn't visible. I tried to access it via Disc Utility device and applied First Aid. An information 'The disc was repaired' popped up but the disc was still not visible. And I tried it on another laptop, this time with Windows. And it cannot be accessed as well.
Is the data on the drive ok? Is the drive crashed? How can I fix it and access my data? Please help

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic