How to use HLOOKUP to quickly get information in Excel

Instead of looking for information one by one in Excel, you may probably have used VLOOKUP formula to quickly get it in a batch. Similarly, HLOOKUP formula enables you to get information in Excel within a few seconds.

However, many people are not quite familiar with the HLOOKUP function in Microsoft Excel. Now I am going to share with you about how to use HLOOKUP in Excel.

How to Use HLOOKUP to Get Correspondent Information

When you want to find out some information related to a designated name, you could achieve it very quickly in Excel.

To use HLOOKUP to get information in Excel:

Step 1: Type the name related to the required information in Excel.

Step 2: Tap “=” and type “hlookup” in the blank that you want to fill the information.

Step 3: Click “HLOOKUP” formula; click the designated name, tap “,”; select the range including the designated name and required information, tap “,”; type “2” as two rows are selected, tap “,”; choose “FALSE” for exact match.

Step 4: Click “Enter”.

After you have finished the HLOOKUP formula,the required information will be displayed in the blank immediately.

How to Use HLOOKUP to Get Multi-Column Information

If you want to getmulti-column information of a designated name in Excel, you could use HLOOKUP functionto achieve it.

To use HLOOKUP toget multi-column information in Excel:

Step 1: Type the name related to the required information in Excel.

Step 2: Tap “=” and type “hlookup” in the first blank that you want to fill the information.

Step 3: Click “HLOOKUP” formula; click the designated name and F4, tap “,”; select the range including the designated name and required information and click F4, tap “,”; type “column” to choose “COLUMN”formula and select the first column of the selected range, tap “,”; choose “FALSE”for exact match.

Step 4: Click “Enter” and drag the bottom right-hand corner of the filled blank towards the right to fill other blanks.

You could immediately get multi-column information after you have completed the stated steps.

How to Use HLOOKUP to Get Information in Designated Columns

When you want to get information in designated columns for someone, you could also quickly make it by using HLOOKUP formula in Excel.

To use HLOOKUP to get information in designated columns in Excel:

Step 1: Type the name related to the required information in excel.

Step2: Tap “=” and type “hlookup” in the first blank that you want to fill the information.

Step3: Click “HLOOKUP” formula; click the designated name and F4, tap “,”; select the range includingthe designated name and required information and click F4, tap “,”; type “match”to choose “MATCH” formula, tap the first item of the required information, and select the column including all required items and tap F4, then choose “0” for exact match; choose “FALSE” for exact match.

Step 4: Click “Enter” and drag the bottom right-hand corner of the filled blank towards the right to fill other blanks.

Explore More Tools to Quickly Get Information in Excel

Except for using HLOOKUP in Microsoft Excel to quickly get information among massive data, WPS Office is an alternative tool with the same formulas that I highly recommend to you. WPS Office is created as a set of office suite which contains World, Excel, PPT and PDF etc., and it is compatible with Microsoft Office files.Therefore, you are free to use WPS Office to open the files saved as Microsoft Office. Most importantly, you could click and download the free WPS Office right now!

If you like this article, please share it with your friends

Leave a Reply

Your email address will not be published. Required fields are marked *