Editing xls is fast and straightforward using DocHub. Skip downloading software to your PC and make adjustments using our drag and drop document editor in a few easy steps. DocHub is more than just a PDF editor. Users praise it for its convenience and powerful features that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and deliver records for completion to other people. All of this, combined with a competing cost, makes DocHub the perfect decision to darken side in xls files effortlessly.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the safety of your data, as we securely store them in the DocHub cloud.
hey guys welcome back to my channel in my tutorial in this particular video Iamp;#39;m going to teach you how to do a reverse we look up now letamp;#39;s say youamp;#39;re working on a huge data set where you canamp;#39;t move around the data but you want to do a reverse we look up for example like in the data case here so I have the model numbers here and I want to look up the brand against it but as you can see in the data the brand comes first here and then the model number and this is not possible in a simple vlookup formula so Iamp;#39;m going to teach you a very simple index-match formula where you can do this reverse we look up so letamp;#39;s get started so Iamp;#39;m going to type in is equals to type in index itamp;#39;s asking me for array Iamp;#39;m going to choose the column here I need the brand here so Iamp;#39;m going to choose that Iamp;#39;m going to press comma type in match lookup value is going to be my model number here comma lookup array is going to be