Getting complete control of your documents at any time is crucial to ease your everyday duties and enhance your efficiency. Achieve any objective with DocHub features for papers management and convenient PDF file editing. Gain access, modify and save and integrate your workflows with other safe cloud storage services.
DocHub gives you lossless editing, the possibility to work with any format, and securely eSign documents without the need of searching for a third-party eSignature alternative. Make the most from the file managing solutions in one place. Try out all DocHub functions today with the free profile.
welcome to Excel campus my name is John and in this video Im going to give a brief overview of the X lookup function X look at this a new function in Excel that Microsoft is calling the successor to vlookup and index match the goal of X lookup is to look for a value in a column or row and return a value from a cell in a matching row or column X lookup has five arguments but only the first three are required those three arguments are the lookup value the lookup array or the column or row to look in and the return array or the column or row to return a value from in this example X lookup is looking for the name in column E and returning the email address from column G this makes for a simple formula that performs an exact match lookup one advantage over vlookup is the separate ranges for the lookup and return arrays this is similar to an index match formula and prevents errors when columns are inserted or deleted another advantage of X lookup is that it returns an exact match by defaul