krokodilizm
New Member
- Joined
- Feb 3, 2016
- Messages
- 20
I'd really google this if I knew how to phrase it properly but it keeps coming up with irrelevant results. Here is my problem:
A1=25,000
A2= a complex chain of formulas that depend on the entries in A1
I'd like to list all A2 results in the range D1:D16 subject to the values in C1:C16.
<colgroup><col style="width:48pt" width="64"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
Any solutions based on a formula or VBA will be welcome.
Thanks
A1=25,000
A2= a complex chain of formulas that depend on the entries in A1
I'd like to list all A2 results in the range D1:D16 subject to the values in C1:C16.
C1 | 25000 |
C2 | 26000 |
C3 | 27000 |
C4 | 28000 |
C5 | 29000 |
C6 | 30000 |
C7 | 31000 |
C8 | 32000 |
C9 | 33000 |
C10 | 34000 |
C11 | 35000 |
C12 | 36000 |
C13 | 37000 |
C14 | 38000 |
C15 | 39000 |
C16 | 40000 |
<colgroup><col style="width:48pt" width="64"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
Any solutions based on a formula or VBA will be welcome.
Thanks