You can’t make document modifications more convenient than editing your ME files on the web. With DocHub, you can access tools to edit documents in fillable PDF, ME, or other formats: highlight, blackout, or erase document elements. Add text and images where you need them, rewrite your form completely, and more. You can download your edited record to your device or share it by email or direct link. You can also convert your documents into fillable forms and invite others to complete them. DocHub even offers an eSignature that allows you to sign and deliver paperwork for signing with just a couple of clicks.
Your records are securely stored in our DocHub cloud, so you can access them at any time from your desktop, laptop, smartphone, or tablet. Should you prefer to apply your mobile device for file editing, you can easily do so with DocHub’s application for iOS or Android.
so we already learned about vlookups and index matches but the problem with these functions is that they only allow us to match up single values but what if we had to do lookups based on multiple criteria for instance in this example which is in the index match array file and I provided a link to these files in the video description if you want to follow along we have three different fields and each of these fields contain different information related to smartphones in column a we have the model okay so itamp;#39;s either an iPhone or a galaxy and column B we have the version so you have the version 9 the X the X are the galaxy 9 or the galaxy 10 and in column C we have the storage now suppose here in so H 8 we wanted to find the quantity available and then cell h 9 we wanted to find the cost for a particular type of phone based on the values in cells h 3 through age 5 well in order to do that weamp;#39;re gonna have to use whatamp;#39;s called an array if we try to do a vlookup or