<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3..org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
h1
{mso-style-name:"Heading 1\,h1\,Level 1 Topic Heading";
mso-style-priority:9;
mso-style-link:"Heading 1 Char\,h1 Char\,Level 1 Topic Heading Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:48.0pt;
margin-left:.65in;
text-indent:-.65in;
page-break-before:always;
page-break-after:avoid;
mso-list:l1 level1 lfo1;
font-size:24.0pt;
font-family:"Cambria","serif";
color:#365F91;
font-weight:normal;}
h2
{mso-style-name:"Heading 2\,h2\,Level 2 Topic Heading\,H2";
mso-style-priority:9;
mso-style-link:"Heading 2 Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:4.0pt;
margin-left:.65in;
text-indent:-.65in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level2 lfo1;
font-size:14.0pt;
font-family:"Cambria","serif";
color:#4F81BD;
font-weight:normal;}
h3
{mso-style-name:"Heading 3\,h3\,Level 3 Topic Heading";
mso-style-priority:9;
mso-style-link:"Heading 3 Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:4.0pt;
margin-left:.85in;
text-indent:-.85in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level3 lfo1;
font-size:13.0pt;
font-family:"Cambria","serif";
color:#4F81BD;
font-weight:normal;}
h4
{mso-style-name:"Heading 4\,h4\,First Subheading";
mso-style-priority:9;
mso-style-link:"Heading 4 Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:4.0pt;
margin-left:1.05in;
text-indent:-1.05in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level4 lfo1;
font-size:12.0pt;
font-family:"Cambria","serif";
color:#4F81BD;
font-weight:normal;}
h5
{mso-style-name:"Heading 5\,h5\,Second Subheading";
mso-style-priority:9;
mso-style-link:"Heading 5 Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:4.0pt;
margin-left:1.25in;
text-indent:-1.25in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level5 lfo1;
font-size:12.0pt;
font-family:"Cambria","serif";
color:#243F60;
font-weight:normal;}
h6
{mso-style-name:"Heading 6\,h6\,Third Subheading";
mso-style-priority:9;
mso-style-link:"Heading 6 Char";
margin-top:8.0pt;
margin-right:0in;
margin-bottom:4.0pt;
margin-left:1.45in;
text-indent:-1.45in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level6 lfo1;
font-size:12.0pt;
font-family:"Cambria","serif";
color:#243F60;
font-weight:normal;}
p.MsoHeading7, li.MsoHeading7, div.MsoHeading7
{mso-style-priority:4;
mso-style-link:"Heading 7 Char";
margin-top:10.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:1.65in;
margin-bottom:.0001pt;
text-indent:-1.65in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level7 lfo1;
font-size:11.0pt;
font-family:"Arial","sans-serif";
color:#243F60;
font-weight:bold;}
p.MsoHeading8, li.MsoHeading8, div.MsoHeading8
{mso-style-priority:4;
mso-style-link:"Heading 8 Char";
margin-top:10.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:1.85in;
margin-bottom:.0001pt;
text-indent:-1.85in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level8 lfo1;
font-size:11.0pt;
font-family:"Arial","sans-serif";
color:#243F60;
font-weight:bold;
font-style:italic;}
p.MsoHeading9, li.MsoHeading9, div.MsoHeading9
{mso-style-priority:4;
mso-style-link:"Heading 9 Char";
margin-top:10.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:2.05in;
margin-bottom:.0001pt;
text-indent:-2.05in;
line-height:115%;
page-break-after:avoid;
mso-list:l1 level9 lfo1;
font-size:11.0pt;
font-family:"Arial","sans-serif";
color:#243F60;
font-style:italic;}
p.MsoListBullet, li.MsoListBullet, div.MsoListBullet
{mso-style-priority:99;
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:.5in;
text-indent:-.25in;
line-height:115%;
mso-list:l0 level1 lfo2;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
p.MsoListBulletCxSpFirst, li.MsoListBulletCxSpFirst, div.MsoListBulletCxSpFirst
{mso-style-priority:99;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
text-indent:-.25in;
line-height:115%;
mso-list:l0 level1 lfo2;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
p.MsoListBulletCxSpMiddle, li.MsoListBulletCxSpMiddle, div.MsoListBulletCxSpMiddle
{mso-style-priority:99;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
text-indent:-.25in;
line-height:115%;
mso-list:l0 level1 lfo2;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
p.MsoListBulletCxSpLast, li.MsoListBulletCxSpLast, div.MsoListBulletCxSpLast
{mso-style-priority:99;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:.5in;
text-indent:-.25in;
line-height:115%;
mso-list:l0 level1 lfo2;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.Heading1Char
{mso-style-name:"Heading 1 Char\,h1 Char\,Level 1 Topic Heading Char";
mso-style-priority:9;
mso-style-link:"Heading 1\,h1\,Level 1 Topic Heading";
font-family:"Cambria","serif";
color:#365F91;}
span.Heading2Char
{mso-style-name:"Heading 2 Char";
mso-style-priority:9;
mso-style-link:"Heading 2\,h2\,Level 2 Topic Heading\,H2";
font-family:"Cambria","serif";
color:#4F81BD;}
span.Heading3Char
{mso-style-name:"Heading 3 Char";
mso-style-priority:9;
mso-style-link:"Heading 3\,h3\,Level 3 Topic Heading";
font-family:"Cambria","serif";
color:#4F81BD;}
span.Heading4Char
{mso-style-name:"Heading 4 Char";
mso-style-priority:9;
mso-style-link:"Heading 4\,h4\,First Subheading";
font-family:"Cambria","serif";
color:#4F81BD;}
span.Heading5Char
{mso-style-name:"Heading 5 Char";
mso-style-priority:9;
mso-style-link:"Heading 5\,h5\,Second Subheading";
font-family:"Cambria","serif";
color:#243F60;}
span.Heading6Char
{mso-style-name:"Heading 6 Char";
mso-style-priority:9;
mso-style-link:"Heading 6\,h6\,Third Subheading";
font-family:"Cambria","serif";
color:#243F60;}
span.Heading7Char
{mso-style-name:"Heading 7 Char";
mso-style-priority:4;
mso-style-link:"Heading 7";
font-family:"Arial","sans-serif";
color:#243F60;
font-weight:bold;}
span.Heading8Char
{mso-style-name:"Heading 8 Char";
mso-style-priority:4;
mso-style-link:"Heading 8";
font-family:"Arial","sans-serif";
color:#243F60;
font-weight:bold;
font-style:italic;}
span.Heading9Char
{mso-style-name:"Heading 9 Char";
mso-style-priority:4;
mso-style-link:"Heading 9";
font-family:"Arial","sans-serif";
color:#243F60;
font-style:italic;}
span.Codefragment
{mso-style-name:"Code fragment";
font-family:Consolas;}
span.Production
{mso-style-name:Production;
font-family:"Times New Roman","serif";
font-style:italic;}
..MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:-119;
mso-list-type:simple;
mso-list-template-ids:1113637348;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-style-link:"List Bullet";
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1
{mso-list-id:703868044;
mso-list-template-ids:-1492236614;
mso-list-style-priority:99;
mso-list-style-name:"Ecma Document Numbering";}
@list l1:level1
{mso-level-style-link:"Heading 1";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.65in;
text-indent:-.65in;}
@list l1:level2
{mso-level-style-link:"Heading 2";
mso-level-text:"%1\.%2";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.65in;
text-indent:-.65in;}
@list l1:level3
{mso-level-style-link:"Heading 3";
mso-level-text:"%1\.%2\.%3";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.85in;
text-indent:-.85in;}
@list l1:level4
{mso-level-style-link:"Heading 4";
mso-level-text:"%1\.%2\.%3\.%4";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.05in;
text-indent:-1.05in;}
@list l1:level5
{mso-level-style-link:"Heading 5";
mso-level-text:"%1\.%2\.%3\.%4\.%5";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-1.25in;}
@list l1:level6
{mso-level-style-link:"Heading 6";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.45in;
text-indent:-1.45in;}
@list l1:level7
{mso-level-style-link:"Heading 7";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.65in;
text-indent:-1.65in;}
@list l1:level8
{mso-level-style-link:"Heading 8";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.85in;
text-indent:-1.85in;}
@list l1:level9
{mso-level-style-link:"Heading 9";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9";
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.05in;
text-indent:-2.05in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Here is my proposed response for this defect report:<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<h1 style='margin-left:0in;text-indent:0in;mso-list:none'><a
name="_Toc224925900"></a><a name="_Toc231548169"></a><a name="_Hlk224397065"><b><span
style='color:#365F91'>DR 09-0146</span> — SML, Formulas: MATCH,
inconsistent use of return value </b></a><b><span style='font-family:Consolas'>#NUM</span></b><b><span
style='font-family:Consolas'>!</span></b><b><span style='font-family:Consolas'><o:p></o:p></span></b></h1>
<p class=MsoNormal><b>Part 1, §18.17.7.204 will be updated as follows:<o:p></o:p></b></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>However, if<o:p></o:p></p>
<p class=MsoListBullet><![if !supportLists]><span lang=EN-CA style='font-family:
Symbol'><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span lang=EN-CA>No match is found, <u><span
style='color:blue'>#N/A</span></u></span><span class=Codefragment><s><span
lang=EN-CA style='color:red'>#NUM!</span></s></span><s><span lang=EN-CA
style='color:red'> </span></s><span lang=EN-CA>is returned.<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>