sathishrosario
New Member
- Joined
- May 20, 2011
- Messages
- 3
Hi to all!!!
Herewith I am attaching the table
<table style="border-collapse: collapse;" height="135" width="395" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 53pt;" width="70"> <col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" height="20" width="64">
</td> <td class="xl65" style="width: 53pt;" width="70">Column 1</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Column 2</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Column 3
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Row 1
</td> <td class="xl66" style="border-top: medium none;">a</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">c</td> <td class="xl67" style="border-top: medium none; border-left: medium none;">Result</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Row 2
</td> <td class="xl68" style="border-top: medium none;">a</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">c</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Row 3
</td> <td class="xl68" style="border-top: medium none;">b</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">d</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Row 4
</td> <td class="xl68" style="border-top: medium none;">a</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">d</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">5</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Row 5
</td> <td class="xl68" style="border-top: medium none;">b</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">c</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">4</td> </tr> </tbody></table>
-- Row 1 and Column 1 matching Cell -- and -- Row 1 and Column 2 matching Cell -- are input cells
-- Row 1 and Column 3 matching Cell -- is Result cell
My Requirement:
If I enter "a" in --Row 1 and Column 1 matching Cell -- and "c" in
-- Row 1 and Column 2 matching Cell -- means the corresponding value from Row 2 to Column 3 range cell has to display in -- Row 1 and Column 3 matching Cell --
Ex:
Row 1 and Column 1 Row 1 and Column 2 Row 1 and Column 3
Input Input Result
a c 1
a d 5
b d 2
b c 4
Your response will be highly appreciated
Thanks with Regards,
sathishrosario@gmail.com
Herewith I am attaching the table
<table style="border-collapse: collapse;" height="135" width="395" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 53pt;" width="70"> <col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" height="20" width="64">
</td> <td class="xl65" style="width: 53pt;" width="70">Column 1</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Column 2</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Column 3
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Row 1
</td> <td class="xl66" style="border-top: medium none;">a</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">c</td> <td class="xl67" style="border-top: medium none; border-left: medium none;">Result</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Row 2
</td> <td class="xl68" style="border-top: medium none;">a</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">c</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Row 3
</td> <td class="xl68" style="border-top: medium none;">b</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">d</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">2</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Row 4
</td> <td class="xl68" style="border-top: medium none;">a</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">d</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">5</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Row 5
</td> <td class="xl68" style="border-top: medium none;">b</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">c</td> <td class="xl68" style="border-top: medium none; border-left: medium none;">4</td> </tr> </tbody></table>
-- Row 1 and Column 1 matching Cell -- and -- Row 1 and Column 2 matching Cell -- are input cells
-- Row 1 and Column 3 matching Cell -- is Result cell
My Requirement:
If I enter "a" in --Row 1 and Column 1 matching Cell -- and "c" in
-- Row 1 and Column 2 matching Cell -- means the corresponding value from Row 2 to Column 3 range cell has to display in -- Row 1 and Column 3 matching Cell --
Ex:
Row 1 and Column 1 Row 1 and Column 2 Row 1 and Column 3
Input Input Result
a c 1
a d 5
b d 2
b c 4
Your response will be highly appreciated
Thanks with Regards,
sathishrosario@gmail.com