When your everyday work consists of lots of document editing, you realize that every document format needs its own approach and often specific applications. Handling a seemingly simple xls file can often grind the whole process to a stop, especially when you are trying to edit with insufficient software. To avoid such difficulties, get an editor that can cover all of your requirements regardless of the file format and join data in xls without roadblocks.
With DocHub, you are going to work with an editing multitool for virtually any situation or document type. Minimize the time you used to devote to navigating your old software’s functionality and learn from our intuitive user interface as you do the job. DocHub is a efficient online editing platform that covers all your document processing requirements for virtually any file, including xls. Open it and go straight to productivity; no prior training or reading manuals is required to reap the benefits DocHub brings to papers management processing. Begin with taking a few minutes to create your account now.
See upgrades in your papers processing right after you open your DocHub profile. Save time on editing with our single platform that can help you be more efficient with any file format with which you need to work.
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 thr