document.write('<div class="feedburnerFeedBlock" id="microsoft/LeTYtfup6euhof2utmvclmt388cpd8">');
document.write('<p class="feedTitle">Lookup Functions</p>');
document.write('<ul>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/324986" target="_blank" >How to use the LOOKUP function in Excel</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/8BJ9IpLjipN3YrQrREhc90Wog04\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/8BJ9IpLjipN3YrQrREhc90Wog04\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/8BJ9IpLjipN3YrQrREhc90Wog04\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/8BJ9IpLjipN3YrQrREhc90Wog04\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>The array form of LOOKUP is similar to the HLOOKUP and VLOOKUP functions. The difference is that HLOOKUP searches for lookup_value in the first row, VLOOKUP searches in the first ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/181212" target="_blank" >How to use the LOOKUP function with unsorted data in Excel</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/p2d5vTeCCTjT4OeQ3wXIKAlXo0k\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/p2d5vTeCCTjT4OeQ3wXIKAlXo0k\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/p2d5vTeCCTjT4OeQ3wXIKAlXo0k\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/p2d5vTeCCTjT4OeQ3wXIKAlXo0k\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>If you are looking for an exact match in Microsoft Excel, the first column of a lookup table does not have to be sorted to use the VLOOKUP and HLOOKUP functions.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214264" target="_blank" >XL: How to Perform a Case-Sensitive Lookup</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/r7qbACdAL81xqOquIjHpo9VqHsU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/r7qbACdAL81xqOquIjHpo9VqHsU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/r7qbACdAL81xqOquIjHpo9VqHsU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/r7qbACdAL81xqOquIjHpo9VqHsU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>You can use LOOKUP functions in Microsoft Excel 97 and later to compare values to find an exact match, but the match is not case-sensitive. However, you can combine the LOOKUP ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/142125" target="_blank" >How to Perform a Case-Sensitive Lookup</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Oy-2ej6pml-UIQxP4kr-jncGT_8\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Oy-2ej6pml-UIQxP4kr-jncGT_8\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Oy-2ej6pml-UIQxP4kr-jncGT_8\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Oy-2ej6pml-UIQxP4kr-jncGT_8\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>You can use lookup functions in Microsoft Excel 7.0 and earlier to compare values to find an exact match, but the match will not be case-sensitive. However, you can combine the ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/dd797422.aspx" target="_blank" >Using the VLookup Function in Excel 2007</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/vbrJ3iJQC6X8Nv-Fa0oQRs40KaU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/vbrJ3iJQC6X8Nv-Fa0oQRs40KaU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/vbrJ3iJQC6X8Nv-Fa0oQRs40KaU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/vbrJ3iJQC6X8Nv-Fa0oQRs40KaU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Returns the relative position of an item in an array that matches a specified value in a specified order. Use MATCH instead of one of the LOOKUP functions when you need the position ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/200855" target="_blank" >XL98: Unexpected Results with Mixed Text and Numbers in Lookup Table</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/tW1xnis6EK7Uvj4UfuN9BYyKfp0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/tW1xnis6EK7Uvj4UfuN9BYyKfp0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/tW1xnis6EK7Uvj4UfuN9BYyKfp0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/tW1xnis6EK7Uvj4UfuN9BYyKfp0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>After you create a lookup table, you may experience either of the following symptoms: Lookup functions on a worksheet may return the #N\/A error value. -or- Lookup functions in a ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213476" target="_blank" >XL: Unexpected Results with Mixed Text and Numbers in Lookup Table</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/fJDwmf-UyafyFditQV5SFNnKEcQ\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/fJDwmf-UyafyFditQV5SFNnKEcQ\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/fJDwmf-UyafyFditQV5SFNnKEcQ\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/fJDwmf-UyafyFditQV5SFNnKEcQ\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>In Microsoft Excel 97 and later, when you create a lookup table, the lookup functions may return the #N\/A error value, or, if you are using the functions in a Microsoft Visual ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/113261" target="_blank" >Unexpected Results with Mixed Text and Numbers in Lookup Table</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Tz_fbtQHh_yKW3nv2xKtQqMb7-c\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Tz_fbtQHh_yKW3nv2xKtQqMb7-c\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Tz_fbtQHh_yKW3nv2xKtQqMb7-c\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Tz_fbtQHh_yKW3nv2xKtQqMb7-c\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>In Microsoft Excel 7.0 and earlier, when you create a lookup table, the lookup functions may return the #N\/A error value, or, if you are using the functions in a Microsoft Visual ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/108639" target="_blank" >XL97: Range_Lookup Argument in VLOOKUP() Finds Exact Match</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/TnAu2FMkc14EhvMV99_orQwPHlI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/TnAu2FMkc14EhvMV99_orQwPHlI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/TnAu2FMkc14EhvMV99_orQwPHlI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/TnAu2FMkc14EhvMV99_orQwPHlI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>In Microsoft Excel versions 5.0 and later, the VLOOKUP() and HLOOKUP() functions contain an argument called range_lookup. The syntax of these functions are different than in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/191114" target="_blank" >XL98: Incorrect LOOKUP() Results with Formula in Lookup_Vector</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/COPQiBX8UXyJ_5I7LIbSarsp-Z0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/COPQiBX8UXyJ_5I7LIbSarsp-Z0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/COPQiBX8UXyJ_5I7LIbSarsp-Z0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/COPQiBX8UXyJ_5I7LIbSarsp-Z0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>The Microsoft Excel 98 Macintosh Edition lookup functions VLOOKUP(), HLOOKUP(), and LOOKUP() may return incorrect results if the lookup vector is the result of a formula.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/324861" target="_blank" >How to find data in an Excel table</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/vmjaFa5rWOMckro0nzesCfN5ILc\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/vmjaFa5rWOMckro0nzesCfN5ILc\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/vmjaFa5rWOMckro0nzesCfN5ILc\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/vmjaFa5rWOMckro0nzesCfN5ILc\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>You can use the INDEX and MATCH functions together to get the same results as using LOOKUP or VLOOKUP. The following is an example of the syntax that combines INDEX and MATCH to ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/248207" target="_blank" >XL2000: Linked Files with Lookup Functions Updated Much More Slowly ...</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/W2VfxPghqj-6HuoimmYVnWNIJXQ\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/W2VfxPghqj-6HuoimmYVnWNIJXQ\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/W2VfxPghqj-6HuoimmYVnWNIJXQ\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/W2VfxPghqj-6HuoimmYVnWNIJXQ\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>When you click Yes to update the links on a workbook that you are opening, Microsoft Excel appears to stop responding (hang). After a long wait, the links are updated, and you gain ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb239415.aspx" target="_blank" >Match Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/uAgZEPxBLdycNWfMD8cikVcf7aQ\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/uAgZEPxBLdycNWfMD8cikVcf7aQ\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/uAgZEPxBLdycNWfMD8cikVcf7aQ\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/uAgZEPxBLdycNWfMD8cikVcf7aQ\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Returns the relative position of an item in an array that matches a specified value in a specified order. Use MATCH instead of one of the LOOKUP functions when you need the ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/59482" target="_blank" >Using INDEX and MATCH Against Multiple Criteria</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/imE2eL_8Q9YJfRjUSta4SGcCU7Q\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/imE2eL_8Q9YJfRjUSta4SGcCU7Q\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/imE2eL_8Q9YJfRjUSta4SGcCU7Q\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/imE2eL_8Q9YJfRjUSta4SGcCU7Q\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>For more information about using lookup functions, click the Index tab in Microsoft Excel 97 Help, type the following text</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/147255" target="_blank" >XL: Using the Lookup Wizard for Microsoft Excel (Lookup.xla)</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/2v-onzkztlkTlzUrv_jq-l9wRYM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/2v-onzkztlkTlzUrv_jq-l9wRYM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/2v-onzkztlkTlzUrv_jq-l9wRYM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/2v-onzkztlkTlzUrv_jq-l9wRYM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>The formulas that the wizard creates use a combination of the lookup functions that are available in Microsoft Excel. Below is a detailed description of each step in the wizard ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/216578" target="_blank" >XL2000: Calculation Differences Between the Office Spreadsheet and ...</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/0pPz2VDCUFpO0-ofCc1oKT9hFVM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/0pPz2VDCUFpO0-ofCc1oKT9hFVM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/0pPz2VDCUFpO0-ofCc1oKT9hFVM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/0pPz2VDCUFpO0-ofCc1oKT9hFVM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Using Tilde Character with Lookup Functions You can search for a value in a list of values and return a value from a column or row you specify using a lookup function.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/181213" target="_blank" >How to Use VLOOKUP or HLOOKUP to find an exact match</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/SEMaqDSyaHHc-pxpqAMjwkEQd7M\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/SEMaqDSyaHHc-pxpqAMjwkEQd7M\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/SEMaqDSyaHHc-pxpqAMjwkEQd7M\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/SEMaqDSyaHHc-pxpqAMjwkEQd7M\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table. Note It is ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214069" target="_blank" >XL: How to Return the First or Last Match in an Array</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/p9XxgMGihnLRpfRzcPYo5b7QNVM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/p9XxgMGihnLRpfRzcPYo5b7QNVM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/p9XxgMGihnLRpfRzcPYo5b7QNVM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/p9XxgMGihnLRpfRzcPYo5b7QNVM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>This behavior is true for the VLOOKUP(), HLOOKUP(), and LOOKUP() functions. To find the first value instead of the last value in an array, use the INDEX() and MATCH() functions.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214252" target="_blank" >HOW TO: Use the Excel Lookup Wizard (Lookup.xla) in Excel 2000</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/mah_jeMiX424YqU-zhJozEWwpwA\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/mah_jeMiX424YqU-zhJozEWwpwA\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/mah_jeMiX424YqU-zhJozEWwpwA\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/mah_jeMiX424YqU-zhJozEWwpwA\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>The formulas that the wizard creates use a combination of the lookup functions that are available in Excel. The following sections describe each step of the wizard.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/249030" target="_blank" >XL97: Linked Files with Lookup Functions Updated Much More Slowly Than ...</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/VYEs7Tt9caWYV0UKpZDWJ4RvnYM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/VYEs7Tt9caWYV0UKpZDWJ4RvnYM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/VYEs7Tt9caWYV0UKpZDWJ4RvnYM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/VYEs7Tt9caWYV0UKpZDWJ4RvnYM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>When you click Yes to update the links on a workbook that you are opening, Microsoft Excel appears to stop responding (hang). After a long wait, the links are updated, and you gain ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/191112" target="_blank" >XL98: Returning the First or Last Match in an Array</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/6CDET8wuArxRVb7cf_fy41qBVqo\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/6CDET8wuArxRVb7cf_fy41qBVqo\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/6CDET8wuArxRVb7cf_fy41qBVqo\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/6CDET8wuArxRVb7cf_fy41qBVqo\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>This behavior is true for the VLOOKUP(), HLOOKUP(), and LOOKUP() functions. To find the first value instead of the last value in an array, you can use the INDEX() and MATCH ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/275170" target="_blank" >HOW TO: Perform a Two-Dimensional Lookup in Excel 2000</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/H-czXY_Me8MXWzi9wQUcitivt0w\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/H-czXY_Me8MXWzi9wQUcitivt0w\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/H-czXY_Me8MXWzi9wQUcitivt0w\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/H-czXY_Me8MXWzi9wQUcitivt0w\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>This article describes two methods to perform a two-dimensional lookup; one method uses the INDEX and MATCH worksheet functions and another method uses natural language formulas.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb225774.aspx" target="_blank" >WorksheetFunction Object Members</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/NQQ1iAOkrw7jB77A6xuqeXYIVEk\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/NQQ1iAOkrw7jB77A6xuqeXYIVEk\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/NQQ1iAOkrw7jB77A6xuqeXYIVEk\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/NQQ1iAOkrw7jB77A6xuqeXYIVEk\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Used as a container for Microsoft Excel worksheet functions that can be called from ... Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb239414.aspx" target="_blank" >Lookup Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/8cHSvetIU9OWuJFvNrf8u3r3mnk\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/8cHSvetIU9OWuJFvNrf8u3r3mnk\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/8cHSvetIU9OWuJFvNrf8u3r3mnk\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/8cHSvetIU9OWuJFvNrf8u3r3mnk\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>The array form of LOOKUP is very similar to the HLOOKUP and VLOOKUP functions. The difference is that HLOOKUP searches for lookup_value in the first row, VLOOKUP searches in the ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=1289" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/-ArY7LWXojXhJirZ7nK8synosI4\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/-ArY7LWXojXhJirZ7nK8synosI4\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/-ArY7LWXojXhJirZ7nK8synosI4\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/-ArY7LWXojXhJirZ7nK8synosI4\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>How-to articles - Lookup Data. How to use the INDEX and MATCH worksheet functions with multiple criteria in Excel Describes how to use the INDEX and MATCH worksheet functions in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513/en-hk?sid=1289" target="_blank" >Microsoft Excel 2004 for Mac</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/tAaLdecAeTT0_0GJAgDPClv4-dU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/tAaLdecAeTT0_0GJAgDPClv4-dU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/tAaLdecAeTT0_0GJAgDPClv4-dU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/tAaLdecAeTT0_0GJAgDPClv4-dU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>How-to articles - Lookup Data. How to use the INDEX and MATCH worksheet functions with multiple criteria in Excel Describes how to use the INDEX and MATCH worksheet functions in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/306604" target="_blank" >Description of the Excel 2000 SR-1 Macro Modification security update ...</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/yefaPSqbcGf3_zTrd8xy-vGZ9t8\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/yefaPSqbcGf3_zTrd8xy-vGZ9t8\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/yefaPSqbcGf3_zTrd8xy-vGZ9t8\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/yefaPSqbcGf3_zTrd8xy-vGZ9t8\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>248207 (http:\/\/support.microsoft.com\/kb\/248207\/EN-US\/ ) XL2000: Linked Files with Lookup Functions Updated Much ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/260893" target="_blank" >Works: Spreadsheet Functions Imported from Excel 2000 to Works</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Z0BhTVYbtzpSqiwfpA11JXyL4vc\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Z0BhTVYbtzpSqiwfpA11JXyL4vc\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Z0BhTVYbtzpSqiwfpA11JXyL4vc\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Z0BhTVYbtzpSqiwfpA11JXyL4vc\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>There are 65 functions in Microsoft Excel that you can import and use in Microsoft Works ... Works does not import the formula if the \"range_lookup ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=1289&aid=1&GSA_AC_More1" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/e4QjkIxp-Vh_UD-PN24RL40DDxM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/e4QjkIxp-Vh_UD-PN24RL40DDxM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/e4QjkIxp-Vh_UD-PN24RL40DDxM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/e4QjkIxp-Vh_UD-PN24RL40DDxM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>How-to articles - Lookup Data. How to use the INDEX and MATCH worksheet functions with multiple criteria in Excel Describes how to use the INDEX and MATCH worksheet functions in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/326667" target="_blank" >Issues that are fixed in Excel 2000 by Office 2000 Service Pack 3</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/nzs7RWYPqzHWqlMS-6l4an4mILY\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/nzs7RWYPqzHWqlMS-6l4an4mILY\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/nzs7RWYPqzHWqlMS-6l4an4mILY\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/nzs7RWYPqzHWqlMS-6l4an4mILY\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>248207 (http:\/\/support.microsoft.com\/kb\/248207\/ ) Linked files with Lookup functions updated much more slowly ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/aa730921.aspx" target="_blank" >Improving Performance in Excel 2007</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/18oLFdEZFDptZNA2kzwMhU8SGx0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/18oLFdEZFDptZNA2kzwMhU8SGx0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/18oLFdEZFDptZNA2kzwMhU8SGx0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/18oLFdEZFDptZNA2kzwMhU8SGx0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>You can efficiently do a two-dimensional table lookup using separate lookups on the rows and columns of a table by using an INDEX function with two embedded MATCH functions, one for ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/248173" target="_blank" >XL2000: Links to Closed Workbook with Defined Names Update Slowly</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/C24Lfaqdy5icG_jfL3nqP6LFtHM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/C24Lfaqdy5icG_jfL3nqP6LFtHM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/C24Lfaqdy5icG_jfL3nqP6LFtHM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/C24Lfaqdy5icG_jfL3nqP6LFtHM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>248207 (http:\/\/support.microsoft.com\/kb\/248207\/EN-US\/ ) XL2000: Linked Files with Lookup Functions Updated Much ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/162762" target="_blank" >Functions Are Not Saved in Lotus 1-2-3 Format</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/jc2rbQv9RKz3YsHg1wmG6kpPFp0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/jc2rbQv9RKz3YsHg1wmG6kpPFp0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/jc2rbQv9RKz3YsHg1wmG6kpPFp0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/jc2rbQv9RKz3YsHg1wmG6kpPFp0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Functions Are Not Saved in Lotus 1-2-3 Format ... LOOKUP MATCH MDETERM MINVERSE MIRR MMULT PPMT PRODUCT SEARCH SUBSTITUTE TEXT TRANSPOSE</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/default.aspx/ph/2512?sid=202" target="_blank" >Excel 2003 Solution Center</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/ODDWA2hyRgo8iRgCFBc1o_yqpDU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/ODDWA2hyRgo8iRgCFBc1o_yqpDU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/ODDWA2hyRgo8iRgCFBc1o_yqpDU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/ODDWA2hyRgo8iRgCFBc1o_yqpDU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Describes how to use the LOOKUP worksheet function to use different formulas that return ... When you use the FORECAST, STEYX, SLOPE or INTERCEPT functions in a Microsoft Office Excel ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=1289&aid=3&GSA_AC_More3" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/z8-fxsqaKwucvUnIqNUtwFTTOPo\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/z8-fxsqaKwucvUnIqNUtwFTTOPo\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/z8-fxsqaKwucvUnIqNUtwFTTOPo\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/z8-fxsqaKwucvUnIqNUtwFTTOPo\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Troubleshooting - Lookup Data. You may obtain incorrect results and misleading labels when ... Suggests using Excel functions to duplicate most of the tool\'s functionality.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com//kb/843504" target="_blank" >Description of the undiscovered tips about Excel</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/VPYkKyAOojD1NfYcSFmo0Of2tSM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/VPYkKyAOojD1NfYcSFmo0Of2tSM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/VPYkKyAOojD1NfYcSFmo0Of2tSM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/VPYkKyAOojD1NfYcSFmo0Of2tSM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>This article describes some of the most powerful and useful features and functions in ... The Range_Lookup argument, is assumed to be TRUE if you do not specify a value.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb211378.aspx" target="_blank" >List of Worksheet Functions Available to Visual Basic\u00A0[Excel 2007 ...</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/HwFi-isyaYK_GhQ_nrXluDPyKw4\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/HwFi-isyaYK_GhQ_nrXluDPyKw4\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/HwFi-isyaYK_GhQ_nrXluDPyKw4\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/HwFi-isyaYK_GhQ_nrXluDPyKw4\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Lookup. Match. Max. MDeterm. MDuration. Median. Min. MInverse. MIrr. MMult. Mode. MRound. MultiNomial ... Events, Worksheet Functions, and Shapes List of Worksheet Functions Available to Visual Basic</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214311" target="_blank" >XL2000: VLOOKUP()\/HLOOKUP() Functions Return Incorrect Value with TFE</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/IaX6L1ijXfGjvWkb7z5FUtRMBHM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/IaX6L1ijXfGjvWkb7z5FUtRMBHM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/IaX6L1ijXfGjvWkb7z5FUtRMBHM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/IaX6L1ijXfGjvWkb7z5FUtRMBHM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>VLOOKUP and HLOOKUP return the index in the lookup array instead of the value at that ... The VLOOKUP and HLOOKUP functions search the first column of an array (top row with ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/61941" target="_blank" >Tips for Importing Lotus 1-2-3 Files to Excel</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/gpbpSIbtl9BVESah_cW1xUgnbWU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/gpbpSIbtl9BVESah_cW1xUgnbWU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/gpbpSIbtl9BVESah_cW1xUgnbWU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/gpbpSIbtl9BVESah_cW1xUgnbWU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>The VLOOKUP and HLOOKUP worksheet functions in Microsoft Excel include a fourth argument, range_lookup. If you set this argument to False, Microsoft Excel searches for ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/87442" target="_blank" >VLOOKUP()\/HLOOKUP() Return Incorrect Value with TFE or AEE</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/RsSgmnnHl15cNgj3OuWulqr6iYg\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/RsSgmnnHl15cNgj3OuWulqr6iYg\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/RsSgmnnHl15cNgj3OuWulqr6iYg\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/RsSgmnnHl15cNgj3OuWulqr6iYg\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>VLOOKUP and HLOOKUP return the index in the lookup array instead of the value at that ... The VLOOKUP and HLOOKUP functions search the first column of an array (top row with ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/185415" target="_blank" >XL98: Functions Are Not Saved in Lotus 1-2-3 Format</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/KwMfGzyej0mZJUPpHg0iOxWt2_8\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/KwMfGzyej0mZJUPpHg0iOxWt2_8\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/KwMfGzyej0mZJUPpHg0iOxWt2_8\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/KwMfGzyej0mZJUPpHg0iOxWt2_8\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>XL98: Functions Are Not Saved in Lotus 1-2-3 Format ... IPMT ISBLANK ISERROR ISLOGICAL LINEST LOGEST LOOKUP MATCH ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/282847" target="_blank" >Some Excel features are unavailable if you disable Visual Basic for ...</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/elyeQJeNfxQi0j_9-VjY2cK_eZI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/elyeQJeNfxQi0j_9-VjY2cK_eZI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/elyeQJeNfxQi0j_9-VjY2cK_eZI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/elyeQJeNfxQi0j_9-VjY2cK_eZI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Lookup Wizard; All other add-ins, including Report Manager and add-ins from third-party vendors; When VBA is not installed, and you open a file that contains functions ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/179841" target="_blank" >XL2000: Tips for Importing Lotus 1-2-3 Files into Microsoft Excel</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Z08pOBCBvrvP_936X5JrkNEU2JI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Z08pOBCBvrvP_936X5JrkNEU2JI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Z08pOBCBvrvP_936X5JrkNEU2JI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Z08pOBCBvrvP_936X5JrkNEU2JI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>The VLOOKUP and HLOOKUP worksheet functions in Microsoft Excel include a fourth argument, range_lookup. If you set this argument to False, Microsoft Excel searches for an exact ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/169105" target="_blank" >XL97: Error Running Wizard When a Control Is Active</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/P4JazbUcKidMLsdP_2PKm7Rz_3Y\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/P4JazbUcKidMLsdP_2PKm7Rz_3Y\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/P4JazbUcKidMLsdP_2PKm7Rz_3Y\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/P4JazbUcKidMLsdP_2PKm7Rz_3Y\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Save as HTML, Conditional Sum, or Lookup ... Certain wizards and functions that require that a cell or a range of cells be selected do ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213528" target="_blank" >XL: Contents of the Samples.xls Workbook</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/P74a23OLBtJhIdvIF8mWGECV8v4\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/P74a23OLBtJhIdvIF8mWGECV8v4\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/P74a23OLBtJhIdvIF8mWGECV8v4\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/P74a23OLBtJhIdvIF8mWGECV8v4\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Worksheet Functions This worksheet contains sample formulas for completing common ... Indexing, matching, and looking up values by using the Lookup Wizard. Calculating ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2512/vi-vn" target="_blank" >Microsoft Office Excel 2003</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/S-98663IoVC1Ga2L74gIuU_3Pug\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/S-98663IoVC1Ga2L74gIuU_3Pug\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/S-98663IoVC1Ga2L74gIuU_3Pug\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/S-98663IoVC1Ga2L74gIuU_3Pug\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>How to Lookup Values in a Range; WebCast: Using XML in Microsoft Office Excel 2003 ... Contains links to articles that discuss the Excel statistical functions in detail.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/149990" target="_blank" >OFF95: Descriptions of Bookshelf Integration Add-Ins</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/8h_Zl3QQAPLhAUE8bZ08fvnQeGg\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/8h_Zl3QQAPLhAUE8bZ08fvnQeGg\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/8h_Zl3QQAPLhAUE8bZ08fvnQeGg\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/8h_Zl3QQAPLhAUE8bZ08fvnQeGg\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>This article gives details about these three add-ins and their functions as they relate to ... Bshxl.xla supports the Copy To Microsoft Excel From Bookshelf and part of the Lookup ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/162323" target="_blank" >XL97: Contents of the Samples.xls Workbook</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/lKPc4plY1BHRbHgDHBm3qytOpos\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/lKPc4plY1BHRbHgDHBm3qytOpos\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/lKPc4plY1BHRbHgDHBm3qytOpos\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/lKPc4plY1BHRbHgDHBm3qytOpos\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>Worksheet Functions This worksheet contains information about suppressing error values in formulas and using the Lookup Wizard to find values in tables of information.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/11346" target="_blank" >Excel 2007 Solution Center</a></span>');
document.write('<div><p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/uzHSxA-O0ZMXZYZ_d9fNY4NK41I\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/uzHSxA-O0ZMXZYZ_d9fNY4NK41I\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/uzHSxA-O0ZMXZYZ_d9fNY4NK41I\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/uzHSxA-O0ZMXZYZ_d9fNY4NK41I\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p>How to use the LOOKUP function in Excel; How to import data ... Find converters and add-ins. Get help when add-ins do not ... Use the INDEX and MATCH worksheet functions with multiple ...</div>');
document.write('</li>');
document.write('</ul>');
document.write(' <p class="fbsubscribelink"><a href="http://feeds.feedburner.com/microsoft/LeTY"><img border="0" src="http://www.feedburner.com/fb/i/icn/feed-icon-10x10.gif"/> Subscribe to this Feed</a></p>');
document.write(' <div id="creditfooter"><a href="http://www.feedburner.com" target="_blank"><img src="http://www.feedburner.com/fb/images/buzzboost-pwrd.gif" alt="Headlines by FeedBurner" style="border:0"/></a></div>');
document.write('</div>');