A point in their 1-1 draw with Blackburn on Friday, thanks to an 85th-minute goal from Bobby Thomas, was enough for Coventry to secure promotion.
Coventry will play in the English top flight for the first time since 2000/01, and Lampard has earned plenty of plaudits for his job.
The Chelsea legend has now been named the Championship Manager of the Season, with his side 10 points clear at the top with five games left to play.
Upon receiving the award, he said: "I was emotional the other night because it dawned on me in that moment what we had achieved.
"A club that I walked into 16 months ago that had gone to the depths and back up, and football is always about people and always about supporters and I'd missed it.
"You have to credit Mark Robins for what he did at the Club, the owner Doug King and appreciate the moment, and I'm working with a great group of players.
"When you walk into a group forget the football talent, that's obviously important, but when they look after themselves, they train well, they support each other, they have a laugh, that's the gold.
"It's an incredible story and I'm please to be a part of it."