Hi,
I'm looking for help on a formula to look up a row based on a cell value and return the average of adjacent cells from that row.
eg: look up Duck and return the average of cells.
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
I'm looking for help on a formula to look up a row based on a cell value and return the average of adjacent cells from that row.
eg: look up Duck and return the average of cells.
Duck | 2 | 1 | 4 | 1 | 3 | 4 |
Chicken | 4 | 5 | 3 | 6 | 3 | 4 |
Dog | 2 | 4 | 3 | 1 | 3 | 5 |
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>