Frank Horatio
New Member
- Joined
- Nov 23, 2010
- Messages
- 14
Using Excel for Mac 2011...
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl65 {border:.5pt solid windowtext;} --> </style> <table style="border-collapse: collapse;width:225pt" border="0" cellpadding="0" cellspacing="0" width="225"> <colgroup><col style="width:65pt" span="2" width="65"> <col style="mso-width-source:userset;mso-width-alt:4053;width:95pt" width="95"> </colgroup><tbody><tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;width:65pt" height="14" width="65">Col A</td> <td class="xl65" style="border-left:none;width:65pt" width="65">Col B</td> <td class="xl65" style="border-left:none;width:95pt" width="95">Col C
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 1</td> <td class="xl65" style="border-top:none;border-left:none">val 9</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 1</td> <td class="xl65" style="border-top:none;border-left:none">val 10</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 1</td> <td class="xl65" style="border-top:none;border-left:none">val 4</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 2</td> <td class="xl65" style="border-top:none;border-left:none">val 4</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 2</td> <td class="xl65" style="border-top:none;border-left:none">val 5</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 3</td> <td class="xl65" style="border-top:none;border-left:none">val 6</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 3</td> <td class="xl65" style="border-top:none;border-left:none">val 4</td> <td class="xl65" style="border-top:none;border-left:none">desired look-up cell</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 3</td> <td class="xl65" style="border-top:none;border-left:none">val 8</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> </tbody></table>
trying to look up the value as indicated in Column C from a different worksheet tab, knowing only the values in Col A and Col B. Not sure how to do this as the Vlookup only gives the the row with "val 3" - "val 6".
Alternatively, if there was a search that returned the row range for "val 3", I think I'd be able to search in that range for "val 4" and find the row I need for Col C.
Thanks!!!!
<style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} @page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl65 {border:.5pt solid windowtext;} --> </style> <table style="border-collapse: collapse;width:225pt" border="0" cellpadding="0" cellspacing="0" width="225"> <colgroup><col style="width:65pt" span="2" width="65"> <col style="mso-width-source:userset;mso-width-alt:4053;width:95pt" width="95"> </colgroup><tbody><tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;width:65pt" height="14" width="65">Col A</td> <td class="xl65" style="border-left:none;width:65pt" width="65">Col B</td> <td class="xl65" style="border-left:none;width:95pt" width="95">Col C
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 1</td> <td class="xl65" style="border-top:none;border-left:none">val 9</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 1</td> <td class="xl65" style="border-top:none;border-left:none">val 10</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 1</td> <td class="xl65" style="border-top:none;border-left:none">val 4</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 2</td> <td class="xl65" style="border-top:none;border-left:none">val 4</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 2</td> <td class="xl65" style="border-top:none;border-left:none">val 5</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 3</td> <td class="xl65" style="border-top:none;border-left:none">val 6</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 3</td> <td class="xl65" style="border-top:none;border-left:none">val 4</td> <td class="xl65" style="border-top:none;border-left:none">desired look-up cell</td> </tr> <tr style="height:14.0pt" height="14"> <td class="xl65" style="height:14.0pt;border-top:none" height="14">val 3</td> <td class="xl65" style="border-top:none;border-left:none">val 8</td> <td class="xl65" style="border-top:none;border-left:none">
</td> </tr> </tbody></table>
trying to look up the value as indicated in Column C from a different worksheet tab, knowing only the values in Col A and Col B. Not sure how to do this as the Vlookup only gives the the row with "val 3" - "val 6".
Alternatively, if there was a search that returned the row range for "val 3", I think I'd be able to search in that range for "val 4" and find the row I need for Col C.
Thanks!!!!
Last edited: