Hello. I have been searching for a way to do this and don't even know the right questions to ask. I have always been able to figure things out without help, except Google, but this has me stumped. What I am trying to do is develop a plant database that will show all plants I will be installing for a client's project and what I'd like to do is have the details auto-populate based on the input of a selected plant. Things like harvest dates, fertilizer recommendations, annual or perennial, water requirements, etc. I'll attach some screen shots.
I have spent 4 hours trying to figure this out. I've tried IF & VLOOKUP and I don't know what else to do. I can make a data sheet for each plant variety or a table but I can't figure it out at all. I know I don't expect anyone to do the work for me, but if you could just point me in the right direction, I'd sure appreciate it! Thanks.
Solved by X. W. in 22 mins