## How to vlookup values from right to left in Excel?

Vlookup is a useful function in Excel, we can use it to quickly return the corresponding data of the leftmost column in the table. However, if you want to look up a specific value in any other column and return the relative value to the left, the normal vlookup function will not work. Here, I can introduce you other formulas to solve this problem.

Vlookup values from right to left with VLOOKUP and IF function

Vlookup values from right to left with INDEX and MATCH function

Vlookup values from right to left with a useful feature

#### Vlookup values from right to left with VLOOKUP and IF function

To get the corresponding left value from the right specific data, the following vlookup function may help you.

Supposing you have a data range, now you know the age of the persons, and you want to get their relative name in the left Name column as following screenshot shown:

=VLOOKUP(F2,IF({1,0},\$D\$2:\$D\$9,\$B\$2:\$B\$9),2,0)

2. Then, drag the fill handle to the cells you want to apply this formula to get all the corresponding names of the specific age. See screenshot:

Notes:

1. In the above formula, F2 is the value which you want to return its relative information, D2:D9 is the column that you are looking for and B2:B9 is the list that contains the value you wish to return.

2. If the specific value you lookup doesn't exist, a #N/A value will be displayed.

Vlookup matching records from the right column in Excel

Kutools for Excel's LOOKUP from Right to Left feature helps you to vlookup and return the left corresponding values based on the right column data in Excel without remembering any painful formulas. Click to download Kutools for Excel!

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!

#### Vlookup values from right to left with INDEX and MATCH function

Except above formula, here is another formula mixed with INDEX and MATCH function also can do you a favor.

1. Enter or copy the below formula into a blank cell to output the result:

=INDEX(\$B\$2:\$B\$9,MATCH(F2,\$D\$2:\$D\$9,0))

2. And then drag the fill handle down to your cells that you want to contain this formula.

Notes:

1. In this formula, F2 is the value which you want to return its relative information, B2:B9 is the list that contains the value you want to return and D2:D9 is the column that you are looking for.

2. If the specific value you lookup doesn't exist, a #N/A value will be displayed.

#### Vlookup values from right to left with a useful feature

If you have Kutools for Excel, with its LOOKUP from Right to Left feature, you can deal with this task quickly without remembering any formulas.

Tips:To apply this LOOKUP from Right to Left feature, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.

After installing Kutools for Excel, please do as this:

1. Click Kutools > Super Lookup > LOOKUP from Right to Left, see screenshot:

2. In the LOOKUP from Right to Left dialog box, please do the following operations:

• Select the lookup value cells and output cells from the Lookup values and Output Range section;
• Then, specify the corresponding items from the Data range section.

Note: If you want to replace the #N/A error value with another text value, you just need to check Replace #N/A error value with a specified value option, and then type the text you need.

3. Then, click OK button, the matching records have been returned based on the lookup values from the right list, see screenshot:

#### More relative articles:

• Vlookup Values Across Multiple Worksheets
• In excel, we can easily apply the vlookup function to return the matching values in a single table of a worksheet. But, have you ever considered that how to vlookup value across multiple worksheet? Supposing I have the following three worksheets with range of data, and now, I want to get part of the corresponding values based on the criteria from these three worksheets.
• Use Vlookup Exact And Approximate Match In Excel
• In Excel, vlookup is one of the most important functions for us to search a value in the left-most column of the table and return the value in the same row of the range. But, do you apply the vlookup function successfully in Excel? This article, I will talk about how to use the vlookup function in Excel.
• Vlookup Matching Value From Bottom To Top In Excel
• Normally, the Vlookup function can help you to find the data from top to bottom to get the first matching value from the list. But, sometimes, you need to vlookup from bottom to top to extract the last corresponding value. Do you have any good ideas to deal with this task in Excel?

• Vlookup And Concatenate Multiple Corresponding Values In Excel
• As we all known, the Vlookup function in Excel can help us to lookup a value and return the corresponding data in another column, but in general, it can only get the first relative value if there are multiple matching data. In this article, I will talk about how to vlookup and concatenate multiple corresponding values in only one cell or a vertical list.

### Best Office Productivity Tools

 🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions… Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ... Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup .... Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List .... Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ... Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ... Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

#### Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!