Hi there!
I see this is post is a few years old, but hopefully this response will happily reach someone looking for answers.
I play several instruments, most happily the guitar. I am not a great piano player, and most of what I know I have taught myself, but I have managed to get through book 4 and occasionally play for sunday schools. I had a few lessons as a child, which I despised, but as I became a young adult I realized the piano is a good skill to have.
My advice is this :
Get a beginning piano book, like John Thompson's, and be sure to keep tempo. Don't look at the keys, just like in typing. After you've gotten familiar with that, you might get the beginning Suzuki book, with the CD. Suzuki is a method where you learn to play by repeating what you have heard, but as an adult I suggest it is easier to become familiar with the notes on the staff, and then listen and look together with Suzuki.
Thompson's book includes some theory, but you would benefit to also get a beginning theory book, as you really need to count the notes and rests properly with the piano. After you have become proficient at book one, go on to book two. By the time you get to books 3 and 4, feel free to pick and choose the songs you like, at that point the books progress beyond drills and you can feel good and accomplished at playing actual tunes.
If you can enroll in a group piano course at a community college, that would be helpful too.
Good Luck!
Pages 1