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