So far we have learned the steps to get the left lookup value with INDEX and MATCH function. Now, We will show the simple formula used to get the Left Lookup value by using the VLOOKUP function along with the CHOOSE function in Excel. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- Use the below formula to get the left lookup values.
=VLOOKUP(A1,CHOOSE({1,2},range2,range1),2,0)
Syntax Explanations:
- VLOOKUP- The VLOOKUP Function will helps to ** lookup data in a range or table by row.**
- CHOOSE – This function will help to return a value from the list of value arguments using a given position or index. Read more on the CHOOSE function.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
- Range – It represents the input ranges in your worksheet.
Practical Example:
Refer to the below steps to get the left lookup values with the VLOOKUP function.
- First, we will enter the input values in Column B and Column C.
- Now, we have entered the age of the persons, and we need to get their relative name in the left Name column as the following screenshot is shown:
- Enter the given formula in the formula bar section.
- Finally, we will get the result in cell F3.
Verdict:
From this tutorial, we have described the formula used to get the left lookup value with the VLOOKUP Function in Excel. If you have any questions, feel free to comment. To learn more, check out Geek Excel!! and Excel Formulas!! Thank you
Top comments (0)