Hi,
On my Excel sheet I have column A full of text. I need a formula that finds/references Aaron in column A (and what ever value is in the cell next to the Aaron in column B). Aaron isn't always in the same cell and can be anywhere in column A. If the figure beside Aaron needs to go into a cell of it's own that's ok, (e.g. Formula cells E1, F1).
<colgroup><col width="64" style="width:48pt"> <col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" style="width:48pt"> <col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>Thanks.
On my Excel sheet I have column A full of text. I need a formula that finds/references Aaron in column A (and what ever value is in the cell next to the Aaron in column B). Aaron isn't always in the same cell and can be anywhere in column A. If the figure beside Aaron needs to go into a cell of it's own that's ok, (e.g. Formula cells E1, F1).
A | B | C | D | E | F | |
1 | Paul | 25 | Aaron | 65 | ||
2 | John | 68 | ||||
3 | Mike | 95 | ||||
4 | Billy | 78 | ||||
5 | Max | 65 | ||||
6 | Max | 25 | ||||
7 | Paul | 54 | ||||
8 | John | 78 | ||||
9 | Aaron | 65 | ||||
10 | Paul | 23 | ||||
11 | Mike | 11 |
<colgroup><col width="64" style="width:48pt"> <col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" style="width:48pt"> <col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>