I deleted an app, it says it's still on my phone in the settings section, how do I retrieve it back?

It says "Open" in the App Store, but I can't open it. IPhone 6

Go to Settings, scroll till you see the Apps button, tap, then search for the app.