Editing excel is fast and straightforward using DocHub. Skip installing software to your PC and make changes using our drag and drop document editor in a few quick steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and powerful capabilities that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and email documents for completion to other people. All of this, put together with a competitive cost, makes DocHub the ideal option to blot authentication in excel files with ease.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the security of your data, as we securely keep them in the DocHub cloud.
let me show you how to find the salary and designation of this employee called tony from this table using x lookup function in the formula bar equal x lookup open parenthesis first argument lookup value tone is the lookup value comma second argument lookup array select the cells containing names comma third argument return array select the cells containing salary and press enter we have the salary of tony now for the designation in the formula bar equal x lookup open parenthesis tony is the lookup value comma range containing employee names is the lookup array comma range containing designations is the return array enter and we have the designation of tony let me change the name here and the formula updated for that change