vlookup retrieve value to the right in Excel

Q64. In Excel, I am not able to use VLOOKUP as the lookup value column is to the right of the column that has the information I need. Is there an alternative option?

For example, I want to enter a Student Name in cell I3 and get the corresponding Percentile Rank information pulled from the table in cell I4 and Student ID information in cell I5..

I can use VLOOKUP for retrieving Percentile Rank value. However, since Student ID column is to the left of Name Column, I am not able to use VLOOKUP.

excel vlookup retrieve value to the right

To do it in Excel, here is the answer:

a) Enter the formula =INDEX(C3:C22,MATCH(I3,D3:D22,0)) in cell I5 where ID for the student selected is required.

The first argument of MATCH "I3" has the Lookup value - the Student name whose ID is to be pulled from the Table.

The second argument of MATCH "D3:D22" is the array range containing the lookup value.

The 3rd argument "0' sets up the function to seek an exact match to the value entered in cell I3.

The Match function returns an Index number of the lookup value in the array.

The Index function then takes this index as its second argument and returns a value from the array specified in its first argument(C3:C22).

excel excel vlookup retrieve value to the right

 

You can find similar Excel Questions and Answer hereunder

1) I have to retrieve data from a specific column in a Table. In Excel, how can I do that?

2) Filtering the value field in a pivot table in Excel

3) How do I disable the right click option for users in my WorkBook?

4) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

5) Is there a way to get a log value of a number using Excel?

6) How can I get the last non-zero value in a row?

7) How can I prevent users from entering duplicate values in a range?

8) Is there a way I can easily identify the duplicate values in a dataset?

9) How can I find the slab in which a given value fits?

10) Given a raw data Table, how can I find the value of a field for a specific value of another field?

11) How can I filter a table to get all records that have less than a particular value in a specific column?

12) Vlookup to return multiple values in same cell in Excel

13) How can I add and link a Chart Title to a cell value?

14) Vlookup to return max value from multiple hits in Excel

15) How do I find the median salary of employees with the same skillset in my Organization?