How do I take information from two sheets and auto populate into a third sheet?
I am trying to set up this smart sheet where it has a entity that someone can select from a drop down menu. Once they clicked any entity I had it V lookup from another sheet and it would auto generate the address for that entity from a different sheet into the cell next to it. I figured out how to do this part.
I am wondering is there a way to do this same function but have it reference two different sheets at the same time. both would have different named entities and different addresses. I don't want to combine then since they are large sheets.
Help Article Resources
Check out the Formula Handbook template!