tgreene2856
New Member
- Joined
- Apr 10, 2013
- Messages
- 30
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>
</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
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