You can’t make document alterations more convenient than editing your excel files on the web. With DocHub, you can access tools to edit documents in fillable PDF, excel, or other formats: highlight, blackout, or erase document fragments. Add text and images where you need them, rewrite your copy completely, and more. You can save your edited file to your device or submit it by email or direct link. You can also convert your documents into fillable forms and invite others to complete them. DocHub even provides an eSignature that allows you to certify and send documents for signing with just a few clicks.
Your documents are safely stored in our DocHub cloud, so you can access them anytime from your PC, laptop, smartphone, or tablet. If you prefer to use your mobile phone for file editing, you can easily do so with DocHub’s mobile app for iOS or Android.
alright so in this video Iamp;#39;m 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 youamp;#39;re in Excel 2016 or a higher version or if youamp;#39;re 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 weamp;#39;re 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 thatamp;#39;s 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