Retrieve data from specific table column in Excel

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.

excel retrieve data from specific table column

To do it in Excel, here is the answer:

a) Enter the formula =VLOOKUP(I3,D3:F22,3,FALSE) in cell I4 where Percentile Rank for the student selected is required.

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

The second argument "D3:F22" is the Table data range with the data of interest. With VLOOKUP function, the first column in Data Range should be the column that has the Look Up value (Student name in this case).

The 3rd argument "3' is the column number in the Table data range from which the result should be pulled from.

The 4th argument of "FALSE" sets up the function to seek an exact match to the value entered in cell I3.

excel retrieve data from specific table column

 

You can find similar Excel Questions and Answer hereunder

1) Split one long column into multiple smaller columns in Excel

2) How can I remove hyperlinks from a range of cells?

3) How can I enter information in multiple cells simultaneously?

4) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

5) How to use data table function in Excel. It helps you go through various scenario when seeking a goal

6) How can I clear all formats (formats alone not data) from a range of cells?

7) How to find the cell address from the column number in VBA

8) How can I extract file name from a full path including folder path and file name?

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

10) How can I identify all cells with Data Validation in my WorkSheet?

 

Here the previous and next chapter