Have you ever struggled with modifying your Xls document while on the go? Well, DocHub has an excellent solution for that! Access this cloud editor from any internet-connected device. It enables users to Join card number in Xls files rapidly and anytime needed.
DocHub will surprise you with what it offers. It has robust capabilities to make whatever changes you want to your forms. And its interface is so simple-to-use that the entire process from start to finish will take you only a few clicks.
Once you complete editing and sharing, you can save your updated Xls file on your device or to the cloud as it is or with an Audit Trail that contains all adjustments applied. Also, you can save your paperwork in its original version or turn it into a multi-use template - accomplish any document management task from anyplace with DocHub. Sign up today!
alright so in this video Im gonna show you how we can avoid doing any vlookups and still be able to join data from different tables in Excel so this is gonna be irrelevant if youre in Excel 2016 or a higher version or if youre in 2010 or 2013 you can also do this by adding an add-on power query to your version so first of all let me just go over what were trying to accomplish here so if I have this transactions data tab and I have this products tab I have connecting columns stock numbers here and if I go to transactions I have stock numbers here too now I want to use that to bring over some data from products to transactions so for example brand Coast maybe size so if I was trying to do this video lookup I would go to transactions and do equals vlookup and then choose the stock number thats connecting peace comma go to products select my array which would start from stock numbers and up lock the range with f4 or however you like locking the ranges comma and then count one two thre