Lookup Conditional Formula with Multiple Columns

matthewlouis

matthewlouis

Active Member
Joined
Mar 28, 2014
Messages
374
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false" DefSemiHidden="false" DefQFormat="false" DefPriority="99" LatentStyleCount="375"> <w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 9"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="header"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footer"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index heading"/> <w:LsdException Locked="false" Priority="35" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="caption"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of figures"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope return"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="line number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="page number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of authorities"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="macro"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="toa heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 5"/> <w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Closing"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Signature"/> <w:LsdException Locked="false" Priority="1" SemiHidden="true" UnhideWhenUsed="true" Name="Default Paragraph Font"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Message Header"/> <w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Salutation"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Date"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Note Heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Block Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Hyperlink"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="FollowedHyperlink"/> <w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Document Map"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Plain Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="E-mail Signature"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Top of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Bottom of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal (Web)"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Acronym"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Cite"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Code"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Definition"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Keyboard"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Preformatted"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Sample"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Typewriter"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Variable"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Table"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation subject"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="No List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Contemporary"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Elegant"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Professional"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Balloon Text"/> <w:LsdException Locked="false" Priority="39" Name="Table Grid"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Theme"/> <w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" Name="Light List"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" SemiHidden="true" Name="Revision"/> <w:LsdException Locked="false" Priority="34" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" SemiHidden="true" UnhideWhenUsed="true" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/> <w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/> <w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/> <w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/> <w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/> <w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/> <w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Mention"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Smart Hyperlink"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Hashtag"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Unresolved Mention"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> I am trying to solve 2 calculations in the table below -- Column G and I. I have already solved Column E.

Column G’s number is found in Column C. Column I’s number is found in Column D. The kicker is these numbers must occur in order.

Once Column E prints, I need a formula for Column G that looks in Column C and prints the FIRST Low (from Column C) that is LOWER than $A$3 AFTER Column E has printed. In this case, the first number that is lower than 2,694.97 ($A$3) is 2,638.17 on 2/5/2018.

Now for Column I. Once Column E and Column F have printed, I need a formula for Column I that looks in Column D (Close) and prints the FIRST Close that is LOWER than $B$3. In this case, there is NOT a number that is lower than 2,694.97 ($A$3) yet. But I still need a formula for that. Here is a formula I was given before – but it isn’t returning the numbers from the table I have manually put in there.

=IF(1-ISNUMBER(LOOKUP(9E+307,$G$1:G2)),IF(ROW()-ROW($G$3)+1>MATCH(9E+307,$E$3:$E$60),MIN(IF(ROW($G$3:$G$60)-ROW($G3)+1>MATCH(9E+307,$E$3:$E$60),IF($C$3:$C$52>$A$2,$C$3:$C$60))),""),"")



[TABLE="class: MsoNormalTable, width: 7"]
<tbody>[TR]
[TD="width: 93"]
A​
[/TD]
[TD="width: 111"]
B​
[/TD]
[TD="width: 93"]
C​
[/TD]
[TD="width: 93"]
D​
[/TD]
[TD="width: 93"]
E​
[/TD]
[TD="width: 93"]
F​
[/TD]
[TD="width: 93"]
G​
[/TD]
[TD="width: 93"]
H​
[/TD]
[TD="width: 93"]
I​
[/TD]
[TD="width: 93"]
J​
[/TD]
[TD="width: 93"][/TD]
[/TR]
[TR]
[TD="width: 93"]
SPH​
[/TD]
[TD="width: 111"]
SPH Low​
[/TD]
[TD="width: 93"]
Low​
[/TD]
[TD="width: 93"]
Close​
[/TD]
[TD="width: 93"]
Closed Over SPH ​
[/TD]
[TD="width: 93"]
Date Closed Over SPH ​
[/TD]
[TD="width: 93"]
Low Price Tested into SPH high​
[/TD]
[TD="width: 93"]
High touched SPH high Date​
[/TD]
[TD="width: 93"]
Closed Under SPH Low​
[/TD]
[TD="width: 93"]
Date Closed Under SPH Low​
[/TD]
[TD="width: 93"]
$SPX.X​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
2,694.97​
[/TD]
[TD="width: 111"]
2,685.92​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
12/18/2017​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
1​
[/TD]
[TD="width: 111"]
12/19/2017​
[/TD]
[TD="width: 93"]
2,680.74​
[/TD]
[TD="width: 93"]
2,681.47​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
2​
[/TD]
[TD="width: 111"]
12/20/2017​
[/TD]
[TD="width: 93"]
2,676.11​
[/TD]
[TD="width: 93"]
2,679.25​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
3​
[/TD]
[TD="width: 111"]
12/21/2017​
[/TD]
[TD="width: 93"]
2,682.40​
[/TD]
[TD="width: 93"]
2,684.57​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
4​
[/TD]
[TD="width: 111"]
12/22/2017​
[/TD]
[TD="width: 93"]
2,678.13​
[/TD]
[TD="width: 93"]
2,683.34​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
5​
[/TD]
[TD="width: 111"]
12/25/2017​
[/TD]
[TD="width: 93"]
2,678.13​
[/TD]
[TD="width: 93"]
2,683.34​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
6​
[/TD]
[TD="width: 111"]
12/26/2017​
[/TD]
[TD="width: 93"]
2,677.96​
[/TD]
[TD="width: 93"]
2,680.50​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
7​
[/TD]
[TD="width: 111"]
12/27/2017​
[/TD]
[TD="width: 93"]
2,678.91​
[/TD]
[TD="width: 93"]
2,682.62​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
8​
[/TD]
[TD="width: 111"]
12/28/2017​
[/TD]
[TD="width: 93"]
2,682.69​
[/TD]
[TD="width: 93"]
2,687.54​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
9​
[/TD]
[TD="width: 111"]
12/29/2017​
[/TD]
[TD="width: 93"]
2,673.61​
[/TD]
[TD="width: 93"]
2,673.61​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
10​
[/TD]
[TD="width: 111"]
1/3/2018​
[/TD]
[TD="width: 93"]
2,697.77​
[/TD]
[TD="width: 93"]
2,713.06​
[/TD]
[TD="width: 93"]
2,713.06​
[/TD]
[TD="width: 93"]
1/3/2018​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
11​
[/TD]
[TD="width: 111"]
1/4/2018​
[/TD]
[TD="width: 93"]
2,719.07​
[/TD]
[TD="width: 93"]
2,723.99​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
12​
[/TD]
[TD="width: 111"]
1/5/2018​
[/TD]
[TD="width: 93"]
2,727.92​
[/TD]
[TD="width: 93"]
2,743.15​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
13​
[/TD]
[TD="width: 111"]
1/8/2018​
[/TD]
[TD="width: 93"]
2,737.60​
[/TD]
[TD="width: 93"]
2,747.71​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
14​
[/TD]
[TD="width: 111"]
1/9/2018​
[/TD]
[TD="width: 93"]
2,747.86​
[/TD]
[TD="width: 93"]
2,751.29​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
15​
[/TD]
[TD="width: 111"]
1/10/2018​
[/TD]
[TD="width: 93"]
2,736.06​
[/TD]
[TD="width: 93"]
2,748.23​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
16​
[/TD]
[TD="width: 111"]
1/11/2018​
[/TD]
[TD="width: 93"]
2,752.78​
[/TD]
[TD="width: 93"]
2,767.56​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
17​
[/TD]
[TD="width: 111"]
1/12/2018​
[/TD]
[TD="width: 93"]
2,769.64​
[/TD]
[TD="width: 93"]
2,786.24​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
18​
[/TD]
[TD="width: 111"]
1/17/2018​
[/TD]
[TD="width: 93"]
2,778.38​
[/TD]
[TD="width: 93"]
2,802.56​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
19​
[/TD]
[TD="width: 111"]
1/18/2018​
[/TD]
[TD="width: 93"]
2,792.56​
[/TD]
[TD="width: 93"]
2,798.03​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
20​
[/TD]
[TD="width: 111"]
1/19/2018​
[/TD]
[TD="width: 93"]
2,798.08​
[/TD]
[TD="width: 93"]
2,810.30​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
21​
[/TD]
[TD="width: 111"]
1/22/2018​
[/TD]
[TD="width: 93"]
2,808.12​
[/TD]
[TD="width: 93"]
2,832.97​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
22​
[/TD]
[TD="width: 111"]
1/23/2018​
[/TD]
[TD="width: 93"]
2,830.59​
[/TD]
[TD="width: 93"]
2,839.13​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
23​
[/TD]
[TD="width: 111"]
1/24/2018​
[/TD]
[TD="width: 93"]
2,824.81​
[/TD]
[TD="width: 93"]
2,837.54​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
24​
[/TD]
[TD="width: 111"]
1/25/2018​
[/TD]
[TD="width: 93"]
2,830.94​
[/TD]
[TD="width: 93"]
2,839.25​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
25​
[/TD]
[TD="width: 111"]
1/26/2018​
[/TD]
[TD="width: 93"]
2,846.18​
[/TD]
[TD="width: 93"]
2,872.87​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
26​
[/TD]
[TD="width: 111"]
1/29/2018​
[/TD]
[TD="width: 93"]
2,851.48​
[/TD]
[TD="width: 93"]
2,853.53​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
27​
[/TD]
[TD="width: 111"]
1/30/2018​
[/TD]
[TD="width: 93"]
2,818.27​
[/TD]
[TD="width: 93"]
2,822.43​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
28​
[/TD]
[TD="width: 111"]
1/31/2018​
[/TD]
[TD="width: 93"]
2,813.04​
[/TD]
[TD="width: 93"]
2,823.81​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
29​
[/TD]
[TD="width: 111"]
2/1/2018​
[/TD]
[TD="width: 93"]
2,812.70​
[/TD]
[TD="width: 93"]
2,821.98​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
30​
[/TD]
[TD="width: 111"]
2/2/2018​
[/TD]
[TD="width: 93"]
2,759.97​
[/TD]
[TD="width: 93"]
2,762.13​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
31​
[/TD]
[TD="width: 111"]
2/5/2018​
[/TD]
[TD="width: 93"]
2,638.17​
[/TD]
[TD="width: 93"]
2,648.94​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"] 2,638.17 [/TD]
[TD="width: 93"]
2/5/2018​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
32​
[/TD]
[TD="width: 111"]
2/6/2018​
[/TD]
[TD="width: 93"]
2,593.07​
[/TD]
[TD="width: 93"]
2,695.14​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
33​
[/TD]
[TD="width: 111"]
2/7/2018​
[/TD]
[TD="width: 93"]
2,681.33​
[/TD]
[TD="width: 93"]
2,681.66​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"] 2,681.66[/TD]
[TD="width: 93"]
2/7/18​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
34​
[/TD]
[TD="width: 111"]
2/8/2018​
[/TD]
[TD="width: 93"]
2,580.56​
[/TD]
[TD="width: 93"]
2,581.00​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
35​
[/TD]
[TD="width: 111"]
2/9/2018​
[/TD]
[TD="width: 93"]
2,532.69​
[/TD]
[TD="width: 93"]
2,619.55​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
36​
[/TD]
[TD="width: 111"]
2/12/2018​
[/TD]
[TD="width: 93"]
2,622.45​
[/TD]
[TD="width: 93"]
2,656.00​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
37​
[/TD]
[TD="width: 111"]
2/13/2018​
[/TD]
[TD="width: 93"]
2,637.08​
[/TD]
[TD="width: 93"]
2,662.94​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
38​
[/TD]
[TD="width: 111"]
2/14/2018​
[/TD]
[TD="width: 93"]
2,648.87​
[/TD]
[TD="width: 93"]
2,698.63​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
39​
[/TD]
[TD="width: 111"]
2/15/2018​
[/TD]
[TD="width: 93"]
2,689.82​
[/TD]
[TD="width: 93"]
2,731.20​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
40​
[/TD]
[TD="width: 111"]
2/16/2018​
[/TD]
[TD="width: 93"]
2,725.11​
[/TD]
[TD="width: 93"]
2,732.22​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
41​
[/TD]
[TD="width: 111"]
2/21/2018​
[/TD]
[TD="width: 93"]
2,701.29​
[/TD]
[TD="width: 93"]
2,701.33​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
42​
[/TD]
[TD="width: 111"]
2/22/2018​
[/TD]
[TD="width: 93"]
2,697.77​
[/TD]
[TD="width: 93"]
2,703.96​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
43​
[/TD]
[TD="width: 111"]
2/23/2018​
[/TD]
[TD="width: 93"]
2,713.74​
[/TD]
[TD="width: 93"]
2,747.30​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
44​
[/TD]
[TD="width: 111"]
2/26/2018​
[/TD]
[TD="width: 93"]
2,753.78​
[/TD]
[TD="width: 93"]
2,779.60​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
45​
[/TD]
[TD="width: 111"]
2/27/2018​
[/TD]
[TD="width: 93"]
2,744.22​
[/TD]
[TD="width: 93"]
2,744.28​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
46​
[/TD]
[TD="width: 111"]
2/28/2018​
[/TD]
[TD="width: 93"]
2,713.54​
[/TD]
[TD="width: 93"]
2,713.83​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
47​
[/TD]
[TD="width: 111"]
3/1/2018​
[/TD]
[TD="width: 93"]
2,659.65​
[/TD]
[TD="width: 93"]
2,677.67​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
48​
[/TD]
[TD="width: 111"]
3/2/2018​
[/TD]
[TD="width: 93"]
#RANGE​
[/TD]
[TD="width: 93"]
#RANGE​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
49​
[/TD]
[TD="width: 111"]
3/5/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
50​
[/TD]
[TD="width: 111"]
3/6/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
51​
[/TD]
[TD="width: 111"]
3/7/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
52​
[/TD]
[TD="width: 111"]
3/8/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
53​
[/TD]
[TD="width: 111"]
3/9/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
54​
[/TD]
[TD="width: 111"]
3/12/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
55​
[/TD]
[TD="width: 111"]
3/13/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
56​
[/TD]
[TD="width: 111"]
3/14/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
57​
[/TD]
[TD="width: 111"]
3/15/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
58​
[/TD]
[TD="width: 111"]
3/16/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
59​
[/TD]
[TD="width: 111"]
3/19/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
[TR]
[TD="width: 93"]
60​
[/TD]
[TD="width: 111"]
3/20/2018​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"]
#ERROR​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"][/TD]
[TD="width: 93"]
#N/A​
[/TD]
[TD="width: 93"]
#REF!​
[/TD]
[/TR]
</tbody>[/TABLE]


Does anyone have any idea how that formula needs to be adjusted?

Thanks for the help in advance!!
 
Last edited:

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
Why not do it all with VBa? it will be much easier to modify , reuse and maintain.
 
Upvote 0
If you have a VBA that work, I would learn how and use it . . . I'm desperate to solve this :eeek:
 
Last edited:
Upvote 0
If I understand corretly what you want, maybe the formulas below can help you:

In G3 and copy down:

=IF(COUNT(E$3:E3),IF(C3<$A$2,IF(COUNT(G$2:G2),"",C3),""),"")

In I3 and copy down:

=IF(COUNT(E$3:E3),IF(D3<$B$2,IF(COUNT(I$2:I2),"",D3),""),"")

Markmzz
 
Upvote 0
The 2nd formula works!!! Thank you so much.

However, the 2nd formula returns the wrong number 2682.36 when it should be 2638.17 on 2/5/2018. I wonder why?


<colgroup><col style="mso-width-source:userset;mso-width-alt:2976; width:70pt" span="11" width="93"> </colgroup><tbody>
[TD="class: xl93, width: 93"]SPH[/TD]
[TD="class: xl93, width: 93"]SPH Low[/TD]
[TD="class: xl93, width: 93"]Low[/TD]
[TD="class: xl94, width: 93"]Close[/TD]
[TD="class: xl95, width: 93"]Closed Over SPH [/TD]
[TD="class: xl95, width: 93"]Date Closed Over SPH [/TD]
[TD="class: xl102, width: 93"]Price Tested into SPH high[/TD]
[TD="class: xl102, width: 93"]High touched SPH high Date[/TD]
[TD="class: xl103, width: 93"]Closed Under SPH Low[/TD]
[TD="class: xl103, width: 93"]Date Closed Under SPH Low[/TD]
[TD="class: xl96, width: 93"]$SPX.X[/TD]

[TD="class: xl90, width: 93"]2,694.97[/TD]
[TD="class: xl92, width: 93"]2,685.92[/TD]
[TD="class: xl91, width: 93"] [/TD]
[TD="class: xl88, width: 93"] [/TD]
[TD="class: xl88, width: 93"] [/TD]
[TD="class: xl87, width: 93"] [/TD]
[TD="class: xl88, width: 93"] [/TD]
[TD="class: xl88, width: 93"] [/TD]
[TD="class: xl88, width: 93"] [/TD]
[TD="class: xl87, width: 93"] [/TD]
[TD="class: xl89, width: 93, align: right"]12/18/2017[/TD]

[TD="class: xl97, width: 93"]0[/TD]
[TD="class: xl101, width: 93"]12/18/2017[/TD]
[TD="class: xl98, width: 93"] [/TD]
[TD="class: xl99, width: 93"] [/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]1[/TD]
[TD="class: xl101, width: 93"]12/19/2017[/TD]
[TD="class: xl98, width: 93"]2,680.74[/TD]
[TD="class: xl99, width: 93"]2,681.47[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]2[/TD]
[TD="class: xl101, width: 93"]12/20/2017[/TD]
[TD="class: xl98, width: 93"]2,676.11[/TD]
[TD="class: xl99, width: 93"]2,679.25[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]3[/TD]
[TD="class: xl101, width: 93"]12/21/2017[/TD]
[TD="class: xl98, width: 93"]2,682.40[/TD]
[TD="class: xl99, width: 93"]2,684.57[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]4[/TD]
[TD="class: xl101, width: 93"]12/22/2017[/TD]
[TD="class: xl98, width: 93"]2,678.13[/TD]
[TD="class: xl99, width: 93"]2,683.34[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]5[/TD]
[TD="class: xl101, width: 93"]12/25/2017[/TD]
[TD="class: xl98, width: 93"]2,678.13[/TD]
[TD="class: xl99, width: 93"]2,683.34[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]6[/TD]
[TD="class: xl101, width: 93"]12/26/2017[/TD]
[TD="class: xl98, width: 93"]2,677.96[/TD]
[TD="class: xl99, width: 93"]2,680.50[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]7[/TD]
[TD="class: xl101, width: 93"]12/27/2017[/TD]
[TD="class: xl98, width: 93"]2,678.91[/TD]
[TD="class: xl99, width: 93"]2,682.62[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]8[/TD]
[TD="class: xl101, width: 93"]12/28/2017[/TD]
[TD="class: xl98, width: 93"]2,682.69[/TD]
[TD="class: xl99, width: 93"]2,687.54[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]9[/TD]
[TD="class: xl101, width: 93"]12/29/2017[/TD]
[TD="class: xl98, width: 93"]2,673.61[/TD]
[TD="class: xl99, width: 93"]2,673.61[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]10[/TD]
[TD="class: xl101, width: 93"]1/2/2018[/TD]
[TD="class: xl98, width: 93"]2,682.36[/TD]
[TD="class: xl99, width: 93"]2,695.81[/TD]
[TD="class: xl100, width: 93, align: right"]2,695.81[/TD]
[TD="class: xl85, width: 93"]1/2/2018[/TD]
[TD="class: xl106, align: right"]2682.3601[/TD]
[TD="class: xl85, width: 93"]1/2/2018[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]11[/TD]
[TD="class: xl101, width: 93"]1/3/2018[/TD]
[TD="class: xl98, width: 93"]2,697.77[/TD]
[TD="class: xl99, width: 93"]2,713.06[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]12[/TD]
[TD="class: xl101, width: 93"]1/4/2018[/TD]
[TD="class: xl98, width: 93"]2,719.07[/TD]
[TD="class: xl99, width: 93"]2,723.99[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]13[/TD]
[TD="class: xl101, width: 93"]1/5/2018[/TD]
[TD="class: xl98, width: 93"]2,727.92[/TD]
[TD="class: xl99, width: 93"]2,743.15[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]14[/TD]
[TD="class: xl101, width: 93"]1/8/2018[/TD]
[TD="class: xl98, width: 93"]2,737.60[/TD]
[TD="class: xl99, width: 93"]2,747.71[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]15[/TD]
[TD="class: xl101, width: 93"]1/9/2018[/TD]
[TD="class: xl98, width: 93"]2,747.86[/TD]
[TD="class: xl99, width: 93"]2,751.29[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]16[/TD]
[TD="class: xl101, width: 93"]1/10/2018[/TD]
[TD="class: xl98, width: 93"]2,736.06[/TD]
[TD="class: xl99, width: 93"]2,748.23[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]17[/TD]
[TD="class: xl101, width: 93"]1/11/2018[/TD]
[TD="class: xl98, width: 93"]2,752.78[/TD]
[TD="class: xl99, width: 93"]2,767.56[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]18[/TD]
[TD="class: xl101, width: 93"]1/12/2018[/TD]
[TD="class: xl98, width: 93"]2,769.64[/TD]
[TD="class: xl99, width: 93"]2,786.24[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]19[/TD]
[TD="class: xl101, width: 93"]1/16/2018[/TD]
[TD="class: xl98, width: 93"]2,768.64[/TD]
[TD="class: xl99, width: 93"]2,776.42[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]20[/TD]
[TD="class: xl101, width: 93"]1/17/2018[/TD]
[TD="class: xl98, width: 93"]2,778.38[/TD]
[TD="class: xl99, width: 93"]2,802.56[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]21[/TD]
[TD="class: xl101, width: 93"]1/18/2018[/TD]
[TD="class: xl98, width: 93"]2,792.56[/TD]
[TD="class: xl99, width: 93"]2,798.03[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]22[/TD]
[TD="class: xl101, width: 93"]1/19/2018[/TD]
[TD="class: xl98, width: 93"]2,798.08[/TD]
[TD="class: xl99, width: 93"]2,810.30[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]23[/TD]
[TD="class: xl101, width: 93"]1/22/2018[/TD]
[TD="class: xl98, width: 93"]2,808.12[/TD]
[TD="class: xl99, width: 93"]2,832.97[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]24[/TD]
[TD="class: xl101, width: 93"]1/23/2018[/TD]
[TD="class: xl98, width: 93"]2,830.59[/TD]
[TD="class: xl99, width: 93"]2,839.13[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]25[/TD]
[TD="class: xl101, width: 93"]1/24/2018[/TD]
[TD="class: xl98, width: 93"]2,824.81[/TD]
[TD="class: xl99, width: 93"]2,837.54[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]26[/TD]
[TD="class: xl101, width: 93"]1/25/2018[/TD]
[TD="class: xl98, width: 93"]2,830.94[/TD]
[TD="class: xl99, width: 93"]2,839.25[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]27[/TD]
[TD="class: xl101, width: 93"]1/26/2018[/TD]
[TD="class: xl98, width: 93"]2,846.18[/TD]
[TD="class: xl99, width: 93"]2,872.87[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]28[/TD]
[TD="class: xl101, width: 93"]1/29/2018[/TD]
[TD="class: xl98, width: 93"]2,851.48[/TD]
[TD="class: xl99, width: 93"]2,853.53[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]29[/TD]
[TD="class: xl101, width: 93"]1/30/2018[/TD]
[TD="class: xl98, width: 93"]2,818.27[/TD]
[TD="class: xl99, width: 93"]2,822.43[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]30[/TD]
[TD="class: xl101, width: 93"]1/31/2018[/TD]
[TD="class: xl98, width: 93"]2,813.04[/TD]
[TD="class: xl99, width: 93"]2,823.81[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]31[/TD]
[TD="class: xl101, width: 93"]2/1/2018[/TD]
[TD="class: xl98, width: 93"]2,812.70[/TD]
[TD="class: xl99, width: 93"]2,821.98[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]32[/TD]
[TD="class: xl101, width: 93"]2/2/2018[/TD]
[TD="class: xl98, width: 93"]2,759.97[/TD]
[TD="class: xl99, width: 93"]2,762.13[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]33[/TD]
[TD="class: xl101, width: 93"]2/5/2018[/TD]
[TD="class: xl98, width: 93"]2,638.17[/TD]
[TD="class: xl99, width: 93"]2,648.94[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105, align: right"]2,648.94[/TD]
[TD="class: xl85, width: 93"]2/5/2018[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]34[/TD]
[TD="class: xl101, width: 93"]2/6/2018[/TD]
[TD="class: xl98, width: 93"]2,593.07[/TD]
[TD="class: xl99, width: 93"]2,695.14[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]35[/TD]
[TD="class: xl101, width: 93"]2/7/2018[/TD]
[TD="class: xl98, width: 93"]2,681.33[/TD]
[TD="class: xl99, width: 93"]2,681.66[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]36[/TD]
[TD="class: xl101, width: 93"]2/8/2018[/TD]
[TD="class: xl98, width: 93"]2,580.56[/TD]
[TD="class: xl99, width: 93"]2,581.00[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]37[/TD]
[TD="class: xl101, width: 93"]2/9/2018[/TD]
[TD="class: xl98, width: 93"]2,532.69[/TD]
[TD="class: xl99, width: 93"]2,619.55[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]38[/TD]
[TD="class: xl101, width: 93"]2/12/2018[/TD]
[TD="class: xl98, width: 93"]2,622.45[/TD]
[TD="class: xl99, width: 93"]2,656.00[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl105"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]39[/TD]
[TD="class: xl101, width: 93"]2/13/2018[/TD]
[TD="class: xl98, width: 93"]2,637.08[/TD]
[TD="class: xl99, width: 93"]2,662.94[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]40[/TD]
[TD="class: xl101, width: 93"]2/14/2018[/TD]
[TD="class: xl98, width: 93"]2,648.87[/TD]
[TD="class: xl99, width: 93"]2,698.63[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]41[/TD]
[TD="class: xl101, width: 93"]2/15/2018[/TD]
[TD="class: xl98, width: 93"]2,689.82[/TD]
[TD="class: xl99, width: 93"]2,731.20[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]42[/TD]
[TD="class: xl101, width: 93"]2/16/2018[/TD]
[TD="class: xl98, width: 93"]2,725.11[/TD]
[TD="class: xl99, width: 93"]2,732.22[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]43[/TD]
[TD="class: xl101, width: 93"]2/20/2018[/TD]
[TD="class: xl98, width: 93"]2,706.76[/TD]
[TD="class: xl99, width: 93"]2,716.26[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]44[/TD]
[TD="class: xl101, width: 93"]2/21/2018[/TD]
[TD="class: xl98, width: 93"]2,701.29[/TD]
[TD="class: xl99, width: 93"]2,701.33[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]45[/TD]
[TD="class: xl101, width: 93"]2/22/2018[/TD]
[TD="class: xl98, width: 93"]2,697.77[/TD]
[TD="class: xl99, width: 93"]2,703.96[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]46[/TD]
[TD="class: xl101, width: 93"]2/23/2018[/TD]
[TD="class: xl98, width: 93"]2,713.74[/TD]
[TD="class: xl99, width: 93"]2,747.30[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]47[/TD]
[TD="class: xl101, width: 93"]2/26/2018[/TD]
[TD="class: xl98, width: 93"]2,753.78[/TD]
[TD="class: xl99, width: 93"]2,779.60[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]48[/TD]
[TD="class: xl101, width: 93"]2/27/2018[/TD]
[TD="class: xl98, width: 93"]2,744.22[/TD]
[TD="class: xl99, width: 93"]2,744.28[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]49[/TD]
[TD="class: xl101, width: 93"]2/28/2018[/TD]
[TD="class: xl98, width: 93"]2,713.54[/TD]
[TD="class: xl99, width: 93"]2,713.83[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]50[/TD]
[TD="class: xl101, width: 93"]3/1/2018[/TD]
[TD="class: xl98, width: 93"]2,659.65[/TD]
[TD="class: xl99, width: 93"]2,677.67[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]51[/TD]
[TD="class: xl101, width: 93"]3/2/2018[/TD]
[TD="class: xl98, width: 93"]2,647.32[/TD]
[TD="class: xl99, width: 93"]2,691.25[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]52[/TD]
[TD="class: xl101, width: 93"]3/5/2018[/TD]
[TD="class: xl98, width: 93"]#ERROR[/TD]
[TD="class: xl99, width: 93"]#ERROR[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]53[/TD]
[TD="class: xl101, width: 93"]3/6/2018[/TD]
[TD="class: xl98, width: 93"]#ERROR[/TD]
[TD="class: xl99, width: 93"]#ERROR[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]54[/TD]
[TD="class: xl101, width: 93"]3/7/2018[/TD]
[TD="class: xl98, width: 93"]#ERROR[/TD]
[TD="class: xl99, width: 93"]#ERROR[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]55[/TD]
[TD="class: xl101, width: 93"]3/8/2018[/TD]
[TD="class: xl98, width: 93"]#ERROR[/TD]
[TD="class: xl99, width: 93"]#ERROR[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]56[/TD]
[TD="class: xl101, width: 93"]3/9/2018[/TD]
[TD="class: xl98, width: 93"]#ERROR[/TD]
[TD="class: xl99, width: 93"]#ERROR[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]57[/TD]
[TD="class: xl101, width: 93"]3/12/2018[/TD]
[TD="class: xl98, width: 93"]#ERROR[/TD]
[TD="class: xl99, width: 93"]#ERROR[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]58[/TD]
[TD="class: xl101, width: 93"]3/13/2018[/TD]
[TD="class: xl98, width: 93"]#ERROR[/TD]
[TD="class: xl99, width: 93"]#ERROR[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]59[/TD]
[TD="class: xl101, width: 93"]3/14/2018[/TD]
[TD="class: xl98, width: 93"]#ERROR[/TD]
[TD="class: xl99, width: 93"]#ERROR[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

[TD="class: xl97, width: 93"]60[/TD]
[TD="class: xl101, width: 93"]3/15/2018[/TD]
[TD="class: xl98, width: 93"]#ERROR[/TD]
[TD="class: xl99, width: 93"]#ERROR[/TD]
[TD="class: xl100, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl106"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl104, width: 93"] [/TD]
[TD="class: xl85, width: 93"]#N/A[/TD]
[TD="class: xl86, width: 93"]#REF![/TD]

</tbody>
 
Upvote 0
matthewlouis said:
The 2nd formula works!!! Thank you so much.

However, the 2nd formula returns the wrong number 2682.36 when it should be 2638.17 on 2/5/2018. I wonder why?
Click to expand...

Try this small modification (in red):

In G3 and copy down:

=IF(COUNT(E$2:E2),IF(C3<$A$2,IF(COUNT(G$2:G2),"",C3),""),"")

In I3 and copy down:

=IF(COUNT(E$2:E2),IF(D3<$B$2,IF(COUNT(I$2:I2),"",D3),""),"")

Markmzz
 
Upvote 0
You must log in or register to reply here.

Similar threads

trishcollins
  • Question Question
Looking for formula/VBA to determine where to best put extra funds
Replies
1
Views
225
trishcollins
trishcollins
K
  • Question Question
How to shorten vba code without any problems
Replies
1
Views
262
kamranyd
K
F
  • Solved
VBA set conditional formatting application-defined or object-defined error
Replies
3
Views
394
Cubist
Cubist
A
  • Question Question
After User Enters A Value (Validation List), Not Automatically Advancing To Next Cell As Per "Select"
Replies
1
Views
382
Ark68
A
A
  • Question Question
Auto Update Sheets in Scheduler file
Replies
6
Views
524
anuradhagrewal
A

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top