compare these two values

[shadow12345]

I have a list of cell address like this

<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td bgcolor="#C0C0C0"> </td>
<td align="center" bgcolor="#C0C0C0"><b>S</b></td><td align="center" bgcolor="#C0C0C0"><b>T</b></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>1</b></td><td rowspan="1" colspan="1" width="192" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$Z$4 </font></td><td rowspan="1" colspan="1" width="339" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AA$6:$AA$1000 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>2</b></td><td rowspan="1" colspan="1" width="192" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AB$4 </font></td><td rowspan="1" colspan="1" width="339" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AC$6:$AC$1000 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>3</b></td><td rowspan="1" colspan="1" width="192" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AD$4 </font></td><td rowspan="1" colspan="1" width="339" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AE$6:$AE$1000 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>4</b></td><td rowspan="1" colspan="1" width="192" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AF$4 </font></td><td rowspan="1" colspan="1" width="339" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AG$6:$AG$1000 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>5</b></td><td rowspan="1" colspan="1" width="192" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AH$4 </font></td><td rowspan="1" colspan="1" width="339" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AI$6:$AI$1000 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>6</b></td><td rowspan="1" colspan="1" width="192" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AJ$4 </font></td><td rowspan="1" colspan="1" width="339" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AK$6:$AK$1000 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>7</b></td><td rowspan="1" colspan="1" width="192" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AL$4 </font></td><td rowspan="1" colspan="1" width="339" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">$AM$6:$AM$1000 </font></td></tr>
</table>

I want to check that Col T row 1 is the next col for the value in Col S

The ones above are all correct.

For example if S3 says Col AD then T3 should be col AE (this goes right from col A to EF so its a long list)

 

[AlphaFrog]

<br /><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>S</th><th>T</th><th>U</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$Z$4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AA$6:$AA$1000</td><td style="text-align: right;border-left: 1px solid black;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AB$4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AC$6:$AC$1000</td><td style="text-align: right;border-left: 1px solid black;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AD$4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AE$6:$AE$1000</td><td style="text-align: right;border-left: 1px solid black;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AF$4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AG$6:$AG$1000</td><td style="text-align: right;border-left: 1px solid black;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AH$4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AI$6:$AI$1000</td><td style="text-align: right;border-left: 1px solid black;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AM$4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AK$6:$AK$1000</td><td style="text-align: right;border-left: 1px solid black;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AL$4</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">$AM$6:$AM$1000</td><td style="text-align: right;border-left: 1px solid black;;">TRUE</td></tr></tbody></table><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">U1</th><td style="text-align:left">=COLUMN(<font color="Blue">INDIRECT(<font color="Red">S1</font>)</font>)+1 = COLUMN(<font color="Blue">INDIRECT(<font color="Red">T1</font>)</font>)</td></tr></tbody></table></td></tr></table><br />

 

[shadow12345]

and thats done it... see its easy when you know how.