Stclements1
Board Regular
- Joined
- Sep 15, 2018
- Messages
- 150
- Office Version
- 365
- Platform
- Windows
1 | 2 | 2 | 3 | 4 | 5 | 6 | 6 | 7 | 8 | 9 | 9 |
550 | 800 | 800 | 1400 | 1600 | 1600 | 1800 | 2000 | 2550 | 2800 | 3600 | 4000 |
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>
I want to write some syntax that allows the numbers on line 1 from 1-9 to match the numbers on line 2 from 550-4000
thus if cell a1 has 4 cell a2 would read 1600