joesalas
New Member
- Joined
- Jun 16, 2005
- Messages
- 27
Would you be able to assist me with a lookup function that joins multiple values based on the value of a "X" flag?
Within a row, gather all cells that equal "X" and join all table header values within a single cell.
Here is a html example:
<Html>
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Item Number</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">North</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">South</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">East</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">West</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Return Value In this Column</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">North, South</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">East</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">3</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">4</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">South, East</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">5</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">East, West</font></td>
</tr>
</table>
</html>
Thanks for your help!
Within a row, gather all cells that equal "X" and join all table header values within a single cell.
Here is a html example:
<Html>
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Item Number</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">North</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">South</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">East</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">West</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Return Value In this Column</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">1</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">North, South</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">2</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">East</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">3</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">4</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">South, East</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">5</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">x</font></td>
<td bgcolor="#FFFFFF" align="center" valign="middle" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">East, West</font></td>
</tr>
</table>
</html>
Thanks for your help!