Look up name in column return info next cell over

[tgreene2856]

I am looking for a formula to search a column for a name then when found give me the data the cell next to it.


Example:

	A	B
1	Name	Age
2	Tim	18
3	Kelly	22
4	Josh	19

<tbody>
</tbody>

Search Column A for Kelly it finds it ins A3 but the result returned is from B3 which would be 22.

Being able to have the formula repeated in the same cell to add multiple rows for the name would be helpful as well.


Thanks


Tim

 

[L. Howard]

Being able to have the formula repeated in the same cell to add multiple rows for the name would be helpful as well.

Hi Tim,

=VLOOKUP(C1,$A$2:$B$4,2,0)

Where you would enter the name in C1.

I don't understand the second part.

Howard