You can’t make document adjustments 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. Include text and pictures where you need them, rewrite your form completely, and more. You can save your edited record to your device or share it by email or direct link. You can also convert your documents into fillable forms and ask others to complete them. DocHub even offers an eSignature that allows you to sign and send 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 computer, laptop, smartphone, or tablet. Should you prefer to apply your mobile phone for file editing, you can easily do it with DocHub’s mobile app for iOS or Android.
so letamp;#39;s take a look at how to write a look-up formula to return multiple values in this example here I want to look up this company name in this table over here and return all the phone numbers for that company and thereamp;#39;s several occurrences of that so you might think of using a vlookup or X lookup for this but that can be a bit challenging to return multiple values and instead weamp;#39;re going to use the new filter function so in this cell right here Iamp;#39;m going to start typing equals filter weamp;#39;ll tab into that and thereamp;#39;s three arguments the first argument is the array and this is the range that we want to return values from so Iamp;#39;m going to select the phone number column here because we want to return phone numbers Iamp;#39;ll type a comma the include argument is our filter criteria so in this case here weamp;#39;re going to select all of the company column and then weamp;#39;re going to set that equals to weamp;#39;ll type equal
