multiple vlookup formula

Excel multiple vlookup formula

VLOOKUP is a powerful function in Excel that allows you to search for a specific value in the first column of a range of cells, and then return a value from the same row in a specified column of that range.

Here are the steps to use VLOOKUP in Excel:

Select the cell where you want to display the result of the VLOOKUP function.
Type the equal sign (=) to start the formula.
Type "VLOOKUP" followed by an opening parenthesis "(".
Type the value you want to look up (also known as the lookup value) within double quotation marks (" "), or reference the cell that contains the lookup value.
Type a comma (,) to separate the lookup value from the table array.
Select the table array that contains the data you want to search and the data that you want to return. The first column of the table array should contain the lookup value, and the column containing the data you want to return should be to the right of the lookup column. You can type the table array manually, or select the range of cells.
Type a comma (,) to separate the table array from the column index number.
Type the column index number of the column that contains the data you want to return. The column index number is the number of the column within the table array, starting from the left-most column, that contains the data you want to return. For example, if the data you want to return is in the third column of the table array, the column index number would be 3.
Type a comma (,) to separate the column index number from the range lookup value.
Type "FALSE" if you want an exact match, or "TRUE" or leave the argument blank if you want an approximate match.
Type a closing parenthesis ")" to complete the formula.
Press Enter to calculate the formula and display the result.
Here is an example of a VLOOKUP function:

=VLOOKUP("Apples",A2:B6,2,FALSE)

In this example, the VLOOKUP function searches for the value "Apples" in the first column of the table array (A2:B6) and returns the corresponding value from the second column of the table array (column B). The "FALSE" argument means that an exact match is required.
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: https://www.facebook.com/profile.php?...
Facebook ID Link: https://www.facebook.com/firozhossen