find field value for specific value in Excel

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

For example, from a class marks table, given a Student First Name, how do I get his / her marks?

To do it in Excel, here is the answer:

a) Enter the formula =INDEX(V3:V12,MATCH(Y3,T3:T12)) where T3:T12 corresponds to all First names in Table, V3:V12 has marks data and Y3 corresponds to the first name of student for whom the marks detail is required.

MATCH returns the relative position of the cell in the "First Name" range that matches the user specified "First Name". INDEX function uses this value as Index to get the marks from range with "Marks".

excel find field value for specific value


You can find similar Excel Questions and Answer hereunder

1) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

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

3) I conducted a test and the test scores are available - how can I get Percentile rank of students?

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

5) Keyboard shortcut for save as in Excel

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

7) How do I get the principal part of loan payment for a period given Loan amount, Rate of Interest and period?

8) How can I ensure that user enters only certain acceptable values in an input cell?

9) I am a construction Engineer. Considering a room with dimension, 14ft x 12ft can I find the side of the largest square tile which can tile the room?

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

11) How do I use Find to determine last occurrence of a string in a WorkSheet range using VBA?

12) How do I get the principal part of loan payment for the year given Loan amount, Rate of Interest and period?

13) Find and count instances of a character in a string in Excel

14) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

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