How to use the HLOOKUP and VLOOKUP functions in Microsoft Excel?

The VLOOKUP and HLOOKUP functions are lookup functions in Excel that allow you to search for specific data in a table and return corresponding values. VLOOKUP searches for a value in the first column of a table and returns a corresponding value in the same row from a specified column. HLOOKUP works similarly, but searches for a value in the first row of a table and returns a corresponding value in the same column from a specified row.

Here are the steps to use the VLOOKUP function in Excel:

1. Open the Microsoft Excel application and create a new worksheet.
2. Select the cell where you want to display the lookup value.
3. Type the equal sign (=) in that cell.
4. Type the word "VLOOKUP" (without quotes) followed by an opening parenthesis.
5. Enter the lookup value that you want to search for. This is the value that you want to find in the first column of the table.
6. Enter the table range where you want to search for the lookup value. The table range should include the first column, the column where the corresponding value is located, and any additional columns you want to include in the result.
7. Enter the column index number of the corresponding value. This is the number of the column where the corresponding value is located, starting from the leftmost column of the table. For example, if the corresponding value is in the second column of the table, enter the number 2.
8. Enter the optional argument "range_lookup" as either TRUE or FALSE. If you enter TRUE, Excel will return an approximate match if an exact match is not found. If you enter FALSE, Excel will only return an exact match.
9. Close the parenthesis and press the "Enter" key to complete the formula and display the result.

Here are the steps to use the HLOOKUP function in Excel:

1. Open the Microsoft Excel application and create a new worksheet.
2. Select the cell where you want to display the lookup value.
3. Type the equal sign (=) in that cell.
4. Type the word "HLOOKUP" (without quotes) followed by an opening parenthesis.
5. Enter the lookup value that you want to search for. This is the value that you want to find in the first row of the table.
6. Enter the table range where you want to search for the lookup value. The table range should include the first row, the row where the corresponding value is located, and any additional rows you want to include in the result.
7. Enter the row index number of the corresponding value. This is the number of the row where the corresponding value is located, starting from the top row of the table. For example, if the corresponding value is in the second row of the table, enter the number 2.
8. Enter the optional argument "range_lookup" as either TRUE or FALSE. If you enter TRUE, Excel will return an approximate match if an exact match is not found. If you enter FALSE, Excel will only return an exact match.
9. Close the parenthesis and press the "Enter" key to complete the formula and display the result.