Xlookup function
XLOOKUP function which is used to extract the cell value from any selected data source with reference to the selected lookup value. XLOOKUP works for the data either it is vertically or horizontally organized which means XLOOKUP has the functionally for both VLOOKUP & HLOOKUP function. Syntax There are 6 arguments used in XLOOKUP function out of which first 3 arguments are required and others are optional as follows. lookup_value : Cell that contain text or number which is selected to search the same from the selected lookup-array and extract the desired value from the selected return_array . lookup-array : Range of cells from the source data that is selected to search the selected lookup_value. return_array Range of cells from the source data that is selected from which the corresponding value will be returned, based on the position of lookup_value in the lookup_array . [if_not_found] (optional) This argument allows th...