Look up name but give data the 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:

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

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

Thanks

Tim

[bebo021999]

Try:

=VLOOKUP("Kelly",A1:B5,2,0)

[AlKey]

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

Row\Col	A	B	C	D	E
1	Name	Age
2	Tim	18		Kelly	22
3	Kelly	22
4	Josh	19

[Tony Valko]

Another possibility as long as the lookup names will not appear more than once.

=SUMIF(A:A,"Kelly",B:B)

[Czeslaw]

Try to apply the pop-up list.