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:
<tbody>
A
B
1
Name
Age
2
Tim
18
3
Kelly
22
4
Josh
19
</tbody>
Search Column A for Kelly it finds it ins A3 but the result returned is from...