Here's one approach which seems to work with your posted data, the rows showing File# in column C are the ones where no matching data was found and Index returned the Column A label.
<table style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 64px"> <col style="WIDTH: 315px"> <col style="WIDTH: 191px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td> </td> <td>A</td> <td>B</td> <td>C</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="BACKGROUND-COLOR: #c0c0c0">File #</td> <td style="BACKGROUND-COLOR: #c0c0c0">File Name</td> <td style="BACKGROUND-COLOR: #c0c0c0">File # Found within Column B</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="TEXT-ALIGN: right">6201</td> <td>File 6201 - Encoding Inv.xml</td> <td style="TEXT-ALIGN: right">6201</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="TEXT-ALIGN: right">6202</td> <td>File 6202 - Submission Tag Mismatch.xml</td> <td style="TEXT-ALIGN: right">6202</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="TEXT-ALIGN: right">6203</td> <td>File 6203 - Submit after submission deadline.xml</td> <td style="TEXT-ALIGN: right">6203</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="TEXT-ALIGN: right">6204</td> <td>File 6204 - Submission Type Tag Inv.xml</td> <td style="TEXT-ALIGN: right">6204</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</td> <td style="TEXT-ALIGN: right">6205</td> <td>File 6204 - Submission Type WARNING.xml</td> <td style="TEXT-ALIGN: right">6204</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</td> <td style="TEXT-ALIGN: right">6206</td> <td>File 6204 - Submission Type VALID.xml</td> <td style="TEXT-ALIGN: right">6204</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="TEXT-ALIGN: right">6207</td> <td>File 6205 - Submission Type Inv.xml</td> <td style="TEXT-ALIGN: right">6205</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</td> <td style="TEXT-ALIGN: right">6208</td> <td>File 6206 - Submission Version Tag Inv.xml</td> <td style="TEXT-ALIGN: right">6206</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</td> <td style="TEXT-ALIGN: right">6209</td> <td>File 6207 - Submission Version Inv.xml</td> <td style="TEXT-ALIGN: right">6207</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</td> <td style="TEXT-ALIGN: right">6210</td> <td>File 6208 - Submission Tag Inv.xml</td> <td style="TEXT-ALIGN: right">6208</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</td> <td style="TEXT-ALIGN: right">6211</td> <td>File 6209 - File Audit Data Tag Inv.xml</td> <td style="TEXT-ALIGN: right">6209</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</td> <td style="TEXT-ALIGN: right">6212</td> <td>File 6210 - File Number WARNING - length.xml</td> <td style="TEXT-ALIGN: right">6210</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</td> <td style="TEXT-ALIGN: right">6213</td> <td>File 6210 - File Number Invalid Data - null.xml</td> <td style="TEXT-ALIGN: right">6210</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</td> <td style="TEXT-ALIGN: right">6214</td> <td>File 6210 - File Number WARNING2 - space.xml</td> <td style="TEXT-ALIGN: right">6210</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</td> <td> </td> <td>File 6210 - File Number Invalid Data - type.xml</td> <td style="TEXT-ALIGN: right">6210</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</td> <td> </td> <td>File 6211 - File Number Tag Inv.xml</td> <td style="TEXT-ALIGN: right">6211</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</td> <td> </td> <td>File 6212 - Number of Files - Invalid Data - length.xml</td> <td style="TEXT-ALIGN: right">6212</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</td> <td> </td> <td>File 6212 - Number of Files - Invalid Data - null.xml</td> <td style="TEXT-ALIGN: right">6212</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</td> <td> </td> <td>File 6212 - Number of Files - VALID - space.xml</td> <td style="TEXT-ALIGN: right">6212</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</td> <td> </td> <td>File 6212 - Number of Files - VALID2 - type.xml</td> <td style="TEXT-ALIGN: right">6212</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</td> <td> </td> <td>File 6213 - Number of Files Tag Inv.xml</td> <td style="TEXT-ALIGN: right">6213</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</td> <td> </td> <td>File 6214 - Create Date Inv WARNING.xml</td> <td style="TEXT-ALIGN: right">6214</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</td> <td> </td> <td>File 6214 - Create Date Inv 011-dd-yyyy.xml</td> <td style="TEXT-ALIGN: right">6214</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</td> <td> </td> <td>File 9214 - Create Date Inv 02-30-yyyy.xml</td> <td>File #</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</td> <td> </td> <td>File 8214 - Create Date Inv VALID.xml</td> <td>File #</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</td> <td> </td> <td>File 7214 - Create Date Inv 06-31-yyyy.xml</td> <td>File #</td></tr></tbody></table>
<table style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"> <tbody> <tr> <td>
Spreadsheet Formulas</td></tr> <tr> <td> <table style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"> <td>Cell</td> <td>Formula</td></tr> <tr> <td>C2</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B2,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C3</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B3,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C4</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B4,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C5</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B5,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C6</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B6,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C7</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B7,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C8</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B8,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C9</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B9,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C10</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B10,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C11</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B11,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C12</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B12,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C13</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B13,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C14</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B14,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C15</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B15,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C16</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B16,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C17</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B17,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C18</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B18,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C19</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B19,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C20</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B20,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C21</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B21,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C22</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B22,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C23</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B23,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C24</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B24,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C25</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B25,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C26</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B26,1)),ROW($A$1:$A$15))),1)}</td></tr> <tr> <td>C27</td> <td>{=INDEX($A$1:$A$15,MIN
(IF(ISNUMBER(FIND($A$1:$A$15,$B27,1)),ROW($A$1:$A$15))),1)}</td></tr></tbody></table></td></tr> <tr> <td>
Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!</td></tr></tbody></table>
Excel tables to the web >> Excel Jeanie HTML 4