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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Grade[/TD]
[TD]%[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD](Search box) Aaron[/TD]
[TD]B+[/TD]
[TD]88.2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Aaron[/TD]
[TD]B+[/TD]
[TD]88.2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD]A[/TD]
[TD]95.4[/TD]
[TD]Great[/TD]
[/TR]
[TR]
[TD]Greg[/TD]
[TD]C[/TD]
[TD]74.6[/TD]
[TD]Average[/TD]
[/TR]
[TR]
[TD]Matt[/TD]
[TD]D-[/TD]
[TD]62.5[/TD]
[TD]Poor[/TD]
[/TR]
</tbody>[/TABLE]

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.