Hello
I'm a new user and wanting to know the formula that will allow me to choose the rate in Column C if Column A is chosen on another sheet?
<colgroup><col span="3"></colgroup><tbody>
</tbody>
Many thanks in advance
Regards
Glee
I'm a new user and wanting to know the formula that will allow me to choose the rate in Column C if Column A is chosen on another sheet?
Column A | Column B | Column C |
Rate A | 10 | 5.85 |
Rate B | 20 | 5.85 |
Rate C | 30 | 8.77 |
Rate D | 40 | 5.85 |
Rate E | 50 | 8.77 |
<colgroup><col span="3"></colgroup><tbody>
</tbody>
Many thanks in advance
Regards
Glee