DocHub makes it quick and simple to rework ein in xls. No need to download any software – simply upload your xls to your account, use the easy drag-and-drop interface, and quickly make edits. You can even work on your PC or mobile device to modify your document online from any place. That's not all; DocHub is more than just an editor. It's an all-in-one document management platform with form constructing, eSignature capabilities, and the option to allow others fill out and sign documents.
Each file you edit you can find in your Documents folder. Create folders and organize records for easier search and retrieval. Additionally, DocHub guarantees the safety of all its users' information by complying with strict security protocols.
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