Stclements1
Board Regular
- Joined
- Sep 15, 2018
- Messages
- 158
- Office Version
- 365
- Platform
- Windows
[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]1[/TD]
[TD="class: xl65, width: 64"]2[/TD]
[TD="class: xl65, width: 64"]2[/TD]
[TD="class: xl65, width: 64"]3[/TD]
[TD="class: xl65, width: 64"]4[/TD]
[TD="class: xl65, width: 64"]5[/TD]
[TD="class: xl65, width: 64"]6[/TD]
[TD="class: xl65, width: 64"]6[/TD]
[TD="class: xl65, width: 64"]7[/TD]
[TD="class: xl65, width: 64"]8[/TD]
[TD="class: xl65, width: 64"]9[/TD]
[TD="class: xl65, width: 64"]9[/TD]
[/TR]
[TR]
[TD="class: xl65"]550[/TD]
[TD="class: xl65"]800[/TD]
[TD="class: xl65"]800[/TD]
[TD="class: xl65"]1400[/TD]
[TD="class: xl65"]1600[/TD]
[TD="class: xl65"]1600[/TD]
[TD="class: xl65"]1800[/TD]
[TD="class: xl65"]2000[/TD]
[TD="class: xl65"]2550[/TD]
[TD="class: xl65"]2800[/TD]
[TD="class: xl65"]3600[/TD]
[TD="class: xl65"]4000[/TD]
[/TR]
</tbody>[/TABLE]
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
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]1[/TD]
[TD="class: xl65, width: 64"]2[/TD]
[TD="class: xl65, width: 64"]2[/TD]
[TD="class: xl65, width: 64"]3[/TD]
[TD="class: xl65, width: 64"]4[/TD]
[TD="class: xl65, width: 64"]5[/TD]
[TD="class: xl65, width: 64"]6[/TD]
[TD="class: xl65, width: 64"]6[/TD]
[TD="class: xl65, width: 64"]7[/TD]
[TD="class: xl65, width: 64"]8[/TD]
[TD="class: xl65, width: 64"]9[/TD]
[TD="class: xl65, width: 64"]9[/TD]
[/TR]
[TR]
[TD="class: xl65"]550[/TD]
[TD="class: xl65"]800[/TD]
[TD="class: xl65"]800[/TD]
[TD="class: xl65"]1400[/TD]
[TD="class: xl65"]1600[/TD]
[TD="class: xl65"]1600[/TD]
[TD="class: xl65"]1800[/TD]
[TD="class: xl65"]2000[/TD]
[TD="class: xl65"]2550[/TD]
[TD="class: xl65"]2800[/TD]
[TD="class: xl65"]3600[/TD]
[TD="class: xl65"]4000[/TD]
[/TR]
</tbody>[/TABLE]
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