retrieve data from specific table column in Excel

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

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 excel retrieve data from specific table column


You can find similar Excel Questions and Answer hereunder

1) How to freeze a row or column in Excel

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

3) I have data arranged in rows of information. Is there any way I can enter new data through a form instead of entering it directly in SpreadSheet?

4) 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?

5) I have WorkBook with sensitive confidential information - how do I encrypt / protect my file so that access to file contents is restricted?

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

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

8) How can I hide a specific Shape in my WorkSheet?

9) How to disable ability to insert Rows and Columns in Excel (using VBA)?

10) Is there a way to easily shade alternate rows in a data range for improving readability?

11) How can I get row count of filtered data?

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

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

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

15) How can I plot 2 series on the same chart with different scales / measurement unit for Values (Ex: Pareto chart)?