DocHub is an all-in-one PDF editor that lets you inject endorsement in xls, and much more. You can highlight, blackout, or remove paperwork fragments, add text and images where you want them, and collect information and signatures. And since it works on any web browser, you won’t need to update your hardware to access its robust capabilities, saving you money. When you have DocHub, a web browser is all you need to handle your xls.
Log in to our service and follow these instructions:
It couldn't be easier! Improve your document processing today with DocHub!
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