You would generally get in-person advice at a nursery (not a garden center like Lowe's, a dedicated nursery), but they will primarily advise you on plants they sell. For houseplants you can get a lot of advice online. A popular forum is garden.org, any time I google advice I invariably find an answer on one of their forum threads. But for me personally houseplants have been trial and error... mostly error... sorry babies u were too good for this world.

https://garden.org/forums/view/houseplants/