Search Function with Personal Data Following

[jamber17]

I have a table of data and have created a search function to find a name within a column of that data. What equation would I need to use to have the next few cells of information that is attached to that name appear in the cells following the search function cell? I used Aaron as an example, but if I changed the name to Greg, then I would want all of his data to appear in the three following cells.

Ex:

Name	Grade	%	Score
(Search box) Aaron	B+	88.2	Good
Aaron	B+	88.2	Good
Daniel	A	95.4	Great
Greg	C	74.6	Average
Matt	D-	62.5	Poor

<tbody>
</tbody>

Need equations for the grade, %, and score cells for the search box row.

 

[Joe4]

Sounds like you want to use VLOOKUP (see: https://www.techonthenet.com/excel/formulas/vlookup.php).

So, let's say that your data underneath the lookup row is A3:D6. Select that whole range and name (something like "MyRange").
If you do not know how to name ranges, see: http://www.contextures.com/xlNames01.html

So, then in cell B2, where you want to lookup the Grade for the person selected in cell A2, enter this formula:

=VLOOKUP($A2,MyRange,COLUMN(),0)

and copy to cells C2 and D2.

This will return the values you want.