XLOOKUP in Microsoft Excel

-

How to use XLOOKUP in Microsoft Excel instead of VLOOKUP?


Basically, XLOOKUP needs 2 arrays, one for the lookup to search for the match and the second is the return array from which the value is returned, whereas VLOOKUP uses a single table array followed by a column index number.

So we can use XLOOKUP if the value that is being searched for is not the first column of the table.

In the below example, we can see that column I is the first array for the search to look for a match and this need not be the first column and column H is the second array which is the return array.


 

Comments

Post a Comment

Popular posts from this blog

SAP ABAP - Generating Excel file for downloading or sending over email

-
Creating excel content from data in an internal table?  Getting the following message when opening an excel created out of SAP - "The file you are trying to open, ‘filename.xls’ is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?" Below is the best solution. This solution is based on the approach used by standard SAP to created excel content from ALV. Once any ALV is displayed, you can get the data into excel using the menu bar option LIST -> EXPORT -> SPREADSHEET.  If there are any questions, put them in the comments.  Sample working code: *&---------------------------------------------------------------------* *& Report Y_EXCEL *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT  Y_EXCEL ...
Read more

Get your signature from a paper to word document

-
Image
Follow the below steps to your signature from a physical hard copy onto a word document. Also ensuring that the background matches. Step 1: Put your signature on a piece of paper and take a snap of it with your mobile camera. Below is what you will have    Step 2: Open a word document that would basically have contents of a letter that you are drafting needing your signature on it and paste the signature pic from step 1 in the appropriate location. Step 3:  The next step is to ensure that the background of the signature is changed so that it matches with the rest of the content on the word document. Right-click on the image and select 'Format Picture' Go to the option of 'Picture Corrections' and set the contrast as '100' The end result is the following:
Read more