Hi,
I was hoping someone could advise what formula can be used for my query?
If I have a full list of unique data in Columns A & B, is there a formula I can use to match up Column A & C and then add the Value1 to the corresponding Value2 field?
The first line is an example where by Value2 is added as it uses Value1 from the first two Columns.
<colgroup><col width="64" span="5" style="width:48pt"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
I was hoping someone could advise what formula can be used for my query?
If I have a full list of unique data in Columns A & B, is there a formula I can use to match up Column A & C and then add the Value1 to the corresponding Value2 field?
The first line is an example where by Value2 is added as it uses Value1 from the first two Columns.
<colgroup><col width="64" span="5" style="width:48pt"></colgroup><tbody>
</tbody>
Name1 | Value1 | Name2 | Value2 |
A | 1 | A | 1 |
B | 2 | C | |
C | 3 | F | |
D | 4 | ||
E | 5 | ||
F | 6 |
<tbody>
</tbody>