Have you ever had trouble with editing your OSHEET document while on the go? Well, DocHub has an excellent solution for that! Access this online editor from any internet-connected device. It enables users to Join detail in OSHEET files rapidly and anytime needed.
DocHub will surprise you with what it provides you with. It has powerful capabilities to make any changes you want to your paperwork. And its interface is so simple-to-use that the entire process from beginning to end will take you only a few clicks.
When you finish editing and sharing, you can save your updated OSHEET document on your device or to the cloud as it is or with an Audit Trail that contains all changes applied. Also, you can save your paperwork in its initial version or transform it into a multi-use template - accomplish any document management task from anywhere with DocHub. Sign up today!
in this video were going to create a formula to join two tables in google sheets using a common key so in this particular example you can see i got this owners table where basically we have a list of names and then we have vin numbers for these vehicles and then if i go to this car info we have vin numbers for some of those vehicles and then some other information and we want to use that common key here and here to basically join these tables so for that im going to start by creating a new sheet down here im going to call it joined tables and were going to get started with our formula so im going to build this formula piece by piece and try to explain you how it works but in the end of the day were going to get just one formula to get us all the results we need so the first thing im going to do im going to start with an equal sign and ill do an array curly bracket here like so and ill go to my first main table owners this one and im going to go