Was wondering if anyone could help me. The sheet below is using the code for vlookupnth ( see below table for code )to get the next row with matching data. It is however returning rows with Zeros between the next set of data that matches the lookup. Is there any way to have the zeros removed so all the data is together? I have tried to sort the data which is on another sheet then re run but same issue. If you need more info please let me know. Thanks
Sort Sheet
<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: 100px"> <col style="WIDTH: 221px"> <col style="WIDTH: 280px"> <col style="WIDTH: 67px"> <col style="WIDTH: 145px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td> </td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td></tr> <tr style="HEIGHT: 27px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSLTOBW0D.1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JR01.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JRp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JK01, JK04, JK06, JR01, JR02, vRBTeam</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JR02.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JRp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JK01.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JKp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JK06.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JKp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JK04.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JKp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 27px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSLTOBB1D.1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JR01.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JRp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JK01, JK04, JK06, JR01, JR02, vRBTeam</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JR02.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JRp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</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>B8</td> <td>=IFERROR(VLOOKUP($B$2,'INS_MEA List'!$B$3:$V$4030,4,FALSE),"")</td></tr> <tr> <td>C8</td> <td>=IFERROR(VLOOKUP($B$2,'INS_MEA List'!$B$3:$V$4030,6,FALSE),"")</td></tr> <tr> <td>D8</td> <td>=IFERROR(VLOOKUP($B$2,'INS_MEA List'!$B$3:$V$4030,7,FALSE),"")</td></tr> <tr> <td>E8</td> <td>=IFERROR(VLOOKUP($B$2,'INS_MEA List'!$B$3:$V$4030,8,FALSE),"")</td></tr> <tr> <td>F8</td> <td>=IFERROR(VLOOKUP($B$2,'INS_MEA List'!$B$3:$V$4030,10,FALSE),"")</td></tr> <tr> <td>B9</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A9),"")</td></tr> <tr> <td>C9</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A9),"")</td></tr> <tr> <td>D9</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A9),"")</td></tr> <tr> <td>E9</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A9),"")</td></tr> <tr> <td>F9</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A9),"")</td></tr> <tr> <td>B10</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A10),"")</td></tr> <tr> <td>C10</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A10),"")</td></tr> <tr> <td>D10</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A10),"")</td></tr> <tr> <td>E10</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A10),"")</td></tr> <tr> <td>F10</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A10),"")</td></tr> <tr> <td>B11</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A11),"")</td></tr> <tr> <td>C11</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A11),"")</td></tr> <tr> <td>D11</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A11),"")</td></tr> <tr> <td>E11</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A11),"")</td></tr> <tr> <td>F11</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A11),"")</td></tr> <tr> <td>B12</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A12),"")</td></tr> <tr> <td>C12</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A12),"")</td></tr> <tr> <td>D12</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A12),"")</td></tr> <tr> <td>E12</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A12),"")</td></tr> <tr> <td>F12</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A12),"")</td></tr> <tr> <td>B13</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A13),"")</td></tr> <tr> <td>C13</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A13),"")</td></tr> <tr> <td>D13</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A13),"")</td></tr> <tr> <td>E13</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A13),"")</td></tr> <tr> <td>F13</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A13),"")</td></tr> <tr> <td>B14</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A14),"")</td></tr> <tr> <td>C14</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A14),"")</td></tr> <tr> <td>D14</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A14),"")</td></tr> <tr> <td>E14</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A14),"")</td></tr> <tr> <td>F14</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A14),"")</td></tr> <tr> <td>B15</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A15),"")</td></tr> <tr> <td>C15</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A15),"")</td></tr> <tr> <td>D15</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A15),"")</td></tr> <tr> <td>E15</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A15),"")</td></tr> <tr> <td>F15</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A15),"")</td></tr> <tr> <td>B16</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A16),"")</td></tr> <tr> <td>C16</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A16),"")</td></tr> <tr> <td>D16</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A16),"")</td></tr> <tr> <td>E16</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A16),"")</td></tr> <tr> <td>F16</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A16),"")</td></tr> <tr> <td>B17</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A17),"")</td></tr> <tr> <td>C17</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A17),"")</td></tr> <tr> <td>D17</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A17),"")</td></tr> <tr> <td>E17</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A17),"")</td></tr> <tr> <td>F17</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A17),"")</td></tr> <tr> <td>B18</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A18),"")</td></tr> <tr> <td>C18</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A18),"")</td></tr> <tr> <td>D18</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A18),"")</td></tr> <tr> <td>E18</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A18),"")</td></tr> <tr> <td>F18</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A18),"")</td></tr> <tr> <td>B19</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A19),"")</td></tr> <tr> <td>C19</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A19),"")</td></tr> <tr> <td>D19</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A19),"")</td></tr> <tr> <td>E19</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A19),"")</td></tr> <tr> <td>F19</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A19),"")</td></tr> <tr> <td>B20</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A20),"")</td></tr> <tr> <td>C20</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A20),"")</td></tr> <tr> <td>D20</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A20),"")</td></tr> <tr> <td>E20</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A20),"")</td></tr> <tr> <td>F20</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A20),"")</td></tr> <tr> <td>B21</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A21),"")</td></tr> <tr> <td>C21</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A21),"")</td></tr> <tr> <td>D21</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A21),"")</td></tr> <tr> <td>E21</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A21),"")</td></tr> <tr> <td>F21</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A21),"")</td></tr> <tr> <td>B22</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A22),"")</td></tr> <tr> <td>C22</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A22),"")</td></tr> <tr> <td>D22</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A22),"")</td></tr> <tr> <td>E22</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A22),"")</td></tr> <tr> <td>F22</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A22),"")</td></tr> <tr> <td>B23</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A23),"")</td></tr> <tr> <td>C23</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A23),"")</td></tr> <tr> <td>D23</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A23),"")</td></tr> <tr> <td>E23</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A23),"")</td></tr> <tr> <td>F23</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A23),"")</td></tr> <tr> <td>B24</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A24),"")</td></tr> <tr> <td>C24</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A24),"")</td></tr> <tr> <td>D24</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A24),"")</td></tr> <tr> <td>E24</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A24),"")</td></tr> <tr> <td>F24</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A24),"")</td></tr> <tr> <td>B25</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A25),"")</td></tr> <tr> <td>C25</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A25),"")</td></tr> <tr> <td>D25</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A25),"")</td></tr> <tr> <td>E25</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A25),"")</td></tr> <tr> <td>F25</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A25),"")</td></tr> <tr> <td>B26</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A26),"")</td></tr> <tr> <td>C26</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A26),"")</td></tr> <tr> <td>D26</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A26),"")</td></tr> <tr> <td>E26</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A26),"")</td></tr> <tr> <td>F26</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A26),"")</td></tr> <tr> <td>B27</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A27),"")</td></tr> <tr> <td>C27</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A27),"")</td></tr> <tr> <td>D27</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A27),"")</td></tr> <tr> <td>E27</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A27),"")</td></tr> <tr> <td>F27</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A27),"")</td></tr> <tr> <td>B28</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A28),"")</td></tr> <tr> <td>C28</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A28),"")</td></tr> <tr> <td>D28</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A28),"")</td></tr> <tr> <td>E28</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A28),"")</td></tr> <tr> <td>F28</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A28),"")</td></tr> <tr> <td>B29</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A29),"")</td></tr> <tr> <td>C29</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A29),"")</td></tr> <tr> <td>D29</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A29),"")</td></tr> <tr> <td>E29</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A29),"")</td></tr> <tr> <td>F29</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A29),"")</td></tr> <tr> <td>B30</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A30),"")</td></tr> <tr> <td>C30</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A30),"")</td></tr> <tr> <td>D30</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A30),"")</td></tr> <tr> <td>E30</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A30),"")</td></tr> <tr> <td>F30</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A30),"")</td></tr> <tr> <td>B31</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A31),"")</td></tr> <tr> <td>C31</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A31),"")</td></tr> <tr> <td>D31</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A31),"")</td></tr> <tr> <td>E31</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A31),"")</td></tr> <tr> <td>F31</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A31),"")</td></tr> <tr> <td>B32</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A32),"")</td></tr> <tr> <td>C32</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A32),"")</td></tr> <tr> <td>D32</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A32),"")</td></tr> <tr> <td>E32</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A32),"")</td></tr> <tr> <td>F32</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A32),"")</td></tr> <tr> <td>B33</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A33),"")</td></tr> <tr> <td>C33</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A33),"")</td></tr> <tr> <td>D33</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A33),"")</td></tr> <tr> <td>E33</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A33),"")</td></tr> <tr> <td>F33</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A33),"")</td></tr> <tr> <td>B34</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A34),"")</td></tr> <tr> <td>C34</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A34),"")</td></tr> <tr> <td>D34</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A34),"")</td></tr> <tr> <td>E34</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A34),"")</td></tr> <tr> <td>F34</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A34),"")</td></tr> <tr> <td>B35</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A35),"")</td></tr> <tr> <td>C35</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A35),"")</td></tr> <tr> <td>D35</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A35),"")</td></tr> <tr> <td>E35</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A35),"")</td></tr> <tr> <td>F35</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A35),"")</td></tr> <tr> <td>B36</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A36),"")</td></tr> <tr> <td>C36</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A36),"")</td></tr> <tr> <td>D36</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A36),"")</td></tr> <tr> <td>E36</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A36),"")</td></tr> <tr> <td>F36</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A36),"")</td></tr> <tr> <td>B37</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A37),"")</td></tr> <tr> <td>C37</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A37),"")</td></tr> <tr> <td>D37</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A37),"")</td></tr> <tr> <td>E37</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A37),"")</td></tr> <tr> <td>F37</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A37),"")</td></tr> <tr> <td>B38</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A38),"")</td></tr> <tr> <td>C38</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A38),"")</td></tr> <tr> <td>D38</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A38),"")</td></tr> <tr> <td>E38</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A38),"")</td></tr> <tr> <td>F38</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A38),"")</td></tr> <tr> <td>B39</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A39),"")</td></tr> <tr> <td>C39</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A39),"")</td></tr> <tr> <td>D39</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A39),"")</td></tr> <tr> <td>E39</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A39),"")</td></tr> <tr> <td>F39</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A39),"")</td></tr></tbody></table></td></tr></tbody></table>
Excel tables to the web >> Excel Jeanie HTML 4
Code:
Option Explicit Public Function VlookupNth(MyVal As Variant, MyRange As Range, Optional ColRef As Long, Optional Nth As Long = 1) ' ' jonmo1 ' http://www.mrexcel.com/board2/viewtopic.php?t=302681&sid=81cc9a966bb7e6a4ca2c63523b1396b7 ' 'Similar to Vlookup, but returns the Nth value found from the top of myrange. 'Not necessarily the First. 'The TRUE/FALSE argument usually found in Vlookup is assumed FALSE in this function. Data does NOT need 'to be sorted, and it searches for EXACT match. 'if ColRef is omitted, uses the number of columns in myrange 'if Nth is omitted, returns the first value found ' Dim Count, i As Long Dim MySheet As Worksheet Count = 0 Set MySheet = Sheets(MyRange.Parent.Name) If ColRef = 0 Then ColRef = MyRange.Columns.Count For i = MyRange.Row To MyRange.Row + MyRange.Rows.Count - 1 If MySheet.Cells(i, MyRange.Column).Value = MyVal Then Count = Count + 1 If Count = Nth Then VlookupNth = MySheet.Cells(i, MyRange.Column + ColRef - 1).Value Exit Function End If End If Next i VlookupNth = "" End Function</pre>
Sort Sheet
<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: 100px"> <col style="WIDTH: 221px"> <col style="WIDTH: 280px"> <col style="WIDTH: 67px"> <col style="WIDTH: 145px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td> </td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td></tr> <tr style="HEIGHT: 27px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSLTOBW0D.1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JR01.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JRp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JK01, JK04, JK06, JR01, JR02, vRBTeam</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JR02.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JRp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JK01.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JKp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JK06.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JKp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JK04.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JKp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td></tr> <tr style="HEIGHT: 27px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSLTOBB1D.1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JR01.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JRp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JK01, JK04, JK06, JR01, JR02, vRBTeam</td></tr> <tr style="HEIGHT: 14px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">INSBEOL/SIL/VECTOR/JR02.LTO800S.0</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">DCVD=Available,LL=Not Use,RL=Not Use</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">JRp_Generic</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 8pt">0</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>B8</td> <td>=IFERROR(VLOOKUP($B$2,'INS_MEA List'!$B$3:$V$4030,4,FALSE),"")</td></tr> <tr> <td>C8</td> <td>=IFERROR(VLOOKUP($B$2,'INS_MEA List'!$B$3:$V$4030,6,FALSE),"")</td></tr> <tr> <td>D8</td> <td>=IFERROR(VLOOKUP($B$2,'INS_MEA List'!$B$3:$V$4030,7,FALSE),"")</td></tr> <tr> <td>E8</td> <td>=IFERROR(VLOOKUP($B$2,'INS_MEA List'!$B$3:$V$4030,8,FALSE),"")</td></tr> <tr> <td>F8</td> <td>=IFERROR(VLOOKUP($B$2,'INS_MEA List'!$B$3:$V$4030,10,FALSE),"")</td></tr> <tr> <td>B9</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A9),"")</td></tr> <tr> <td>C9</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A9),"")</td></tr> <tr> <td>D9</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A9),"")</td></tr> <tr> <td>E9</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A9),"")</td></tr> <tr> <td>F9</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A9),"")</td></tr> <tr> <td>B10</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A10),"")</td></tr> <tr> <td>C10</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A10),"")</td></tr> <tr> <td>D10</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A10),"")</td></tr> <tr> <td>E10</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A10),"")</td></tr> <tr> <td>F10</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A10),"")</td></tr> <tr> <td>B11</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A11),"")</td></tr> <tr> <td>C11</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A11),"")</td></tr> <tr> <td>D11</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A11),"")</td></tr> <tr> <td>E11</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A11),"")</td></tr> <tr> <td>F11</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A11),"")</td></tr> <tr> <td>B12</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A12),"")</td></tr> <tr> <td>C12</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A12),"")</td></tr> <tr> <td>D12</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A12),"")</td></tr> <tr> <td>E12</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A12),"")</td></tr> <tr> <td>F12</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A12),"")</td></tr> <tr> <td>B13</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A13),"")</td></tr> <tr> <td>C13</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A13),"")</td></tr> <tr> <td>D13</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A13),"")</td></tr> <tr> <td>E13</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A13),"")</td></tr> <tr> <td>F13</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A13),"")</td></tr> <tr> <td>B14</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A14),"")</td></tr> <tr> <td>C14</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A14),"")</td></tr> <tr> <td>D14</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A14),"")</td></tr> <tr> <td>E14</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A14),"")</td></tr> <tr> <td>F14</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A14),"")</td></tr> <tr> <td>B15</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A15),"")</td></tr> <tr> <td>C15</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A15),"")</td></tr> <tr> <td>D15</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A15),"")</td></tr> <tr> <td>E15</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A15),"")</td></tr> <tr> <td>F15</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A15),"")</td></tr> <tr> <td>B16</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A16),"")</td></tr> <tr> <td>C16</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A16),"")</td></tr> <tr> <td>D16</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A16),"")</td></tr> <tr> <td>E16</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A16),"")</td></tr> <tr> <td>F16</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A16),"")</td></tr> <tr> <td>B17</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A17),"")</td></tr> <tr> <td>C17</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A17),"")</td></tr> <tr> <td>D17</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A17),"")</td></tr> <tr> <td>E17</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A17),"")</td></tr> <tr> <td>F17</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A17),"")</td></tr> <tr> <td>B18</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A18),"")</td></tr> <tr> <td>C18</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A18),"")</td></tr> <tr> <td>D18</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A18),"")</td></tr> <tr> <td>E18</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A18),"")</td></tr> <tr> <td>F18</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A18),"")</td></tr> <tr> <td>B19</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A19),"")</td></tr> <tr> <td>C19</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A19),"")</td></tr> <tr> <td>D19</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A19),"")</td></tr> <tr> <td>E19</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A19),"")</td></tr> <tr> <td>F19</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A19),"")</td></tr> <tr> <td>B20</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A20),"")</td></tr> <tr> <td>C20</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A20),"")</td></tr> <tr> <td>D20</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A20),"")</td></tr> <tr> <td>E20</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A20),"")</td></tr> <tr> <td>F20</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A20),"")</td></tr> <tr> <td>B21</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A21),"")</td></tr> <tr> <td>C21</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A21),"")</td></tr> <tr> <td>D21</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A21),"")</td></tr> <tr> <td>E21</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A21),"")</td></tr> <tr> <td>F21</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A21),"")</td></tr> <tr> <td>B22</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A22),"")</td></tr> <tr> <td>C22</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A22),"")</td></tr> <tr> <td>D22</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A22),"")</td></tr> <tr> <td>E22</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A22),"")</td></tr> <tr> <td>F22</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A22),"")</td></tr> <tr> <td>B23</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A23),"")</td></tr> <tr> <td>C23</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A23),"")</td></tr> <tr> <td>D23</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A23),"")</td></tr> <tr> <td>E23</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A23),"")</td></tr> <tr> <td>F23</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A23),"")</td></tr> <tr> <td>B24</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A24),"")</td></tr> <tr> <td>C24</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A24),"")</td></tr> <tr> <td>D24</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A24),"")</td></tr> <tr> <td>E24</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A24),"")</td></tr> <tr> <td>F24</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A24),"")</td></tr> <tr> <td>B25</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A25),"")</td></tr> <tr> <td>C25</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A25),"")</td></tr> <tr> <td>D25</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A25),"")</td></tr> <tr> <td>E25</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A25),"")</td></tr> <tr> <td>F25</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A25),"")</td></tr> <tr> <td>B26</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A26),"")</td></tr> <tr> <td>C26</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A26),"")</td></tr> <tr> <td>D26</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A26),"")</td></tr> <tr> <td>E26</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A26),"")</td></tr> <tr> <td>F26</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A26),"")</td></tr> <tr> <td>B27</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A27),"")</td></tr> <tr> <td>C27</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A27),"")</td></tr> <tr> <td>D27</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A27),"")</td></tr> <tr> <td>E27</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A27),"")</td></tr> <tr> <td>F27</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A27),"")</td></tr> <tr> <td>B28</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A28),"")</td></tr> <tr> <td>C28</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A28),"")</td></tr> <tr> <td>D28</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A28),"")</td></tr> <tr> <td>E28</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A28),"")</td></tr> <tr> <td>F28</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A28),"")</td></tr> <tr> <td>B29</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A29),"")</td></tr> <tr> <td>C29</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A29),"")</td></tr> <tr> <td>D29</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A29),"")</td></tr> <tr> <td>E29</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A29),"")</td></tr> <tr> <td>F29</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A29),"")</td></tr> <tr> <td>B30</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A30),"")</td></tr> <tr> <td>C30</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A30),"")</td></tr> <tr> <td>D30</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A30),"")</td></tr> <tr> <td>E30</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A30),"")</td></tr> <tr> <td>F30</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A30),"")</td></tr> <tr> <td>B31</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A31),"")</td></tr> <tr> <td>C31</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A31),"")</td></tr> <tr> <td>D31</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A31),"")</td></tr> <tr> <td>E31</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A31),"")</td></tr> <tr> <td>F31</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A31),"")</td></tr> <tr> <td>B32</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A32),"")</td></tr> <tr> <td>C32</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A32),"")</td></tr> <tr> <td>D32</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A32),"")</td></tr> <tr> <td>E32</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A32),"")</td></tr> <tr> <td>F32</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A32),"")</td></tr> <tr> <td>B33</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A33),"")</td></tr> <tr> <td>C33</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A33),"")</td></tr> <tr> <td>D33</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A33),"")</td></tr> <tr> <td>E33</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A33),"")</td></tr> <tr> <td>F33</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A33),"")</td></tr> <tr> <td>B34</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A34),"")</td></tr> <tr> <td>C34</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A34),"")</td></tr> <tr> <td>D34</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A34),"")</td></tr> <tr> <td>E34</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A34),"")</td></tr> <tr> <td>F34</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A34),"")</td></tr> <tr> <td>B35</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A35),"")</td></tr> <tr> <td>C35</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A35),"")</td></tr> <tr> <td>D35</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A35),"")</td></tr> <tr> <td>E35</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A35),"")</td></tr> <tr> <td>F35</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A35),"")</td></tr> <tr> <td>B36</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A36),"")</td></tr> <tr> <td>C36</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A36),"")</td></tr> <tr> <td>D36</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A36),"")</td></tr> <tr> <td>E36</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A36),"")</td></tr> <tr> <td>F36</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A36),"")</td></tr> <tr> <td>B37</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A37),"")</td></tr> <tr> <td>C37</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A37),"")</td></tr> <tr> <td>D37</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A37),"")</td></tr> <tr> <td>E37</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A37),"")</td></tr> <tr> <td>F37</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A37),"")</td></tr> <tr> <td>B38</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A38),"")</td></tr> <tr> <td>C38</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A38),"")</td></tr> <tr> <td>D38</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A38),"")</td></tr> <tr> <td>E38</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A38),"")</td></tr> <tr> <td>F38</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A38),"")</td></tr> <tr> <td>B39</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$Y$4030,4,A39),"")</td></tr> <tr> <td>C39</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,6,A39),"")</td></tr> <tr> <td>D39</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,7,A39),"")</td></tr> <tr> <td>E39</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,8,A39),"")</td></tr> <tr> <td>F39</td> <td>=IFERROR(Vlookupnth($B$2,'INS_MEA List'!$B$3:$V$4030,10,A39),"")</td></tr></tbody></table></td></tr></tbody></table>
Excel tables to the web >> Excel Jeanie HTML 4
Code:
Option Explicit Public Function VlookupNth(MyVal As Variant, MyRange As Range, Optional ColRef As Long, Optional Nth As Long = 1) ' ' jonmo1 ' http://www.mrexcel.com/board2/viewtopic.php?t=302681&sid=81cc9a966bb7e6a4ca2c63523b1396b7 ' 'Similar to Vlookup, but returns the Nth value found from the top of myrange. 'Not necessarily the First. 'The TRUE/FALSE argument usually found in Vlookup is assumed FALSE in this function. Data does NOT need 'to be sorted, and it searches for EXACT match. 'if ColRef is omitted, uses the number of columns in myrange 'if Nth is omitted, returns the first value found ' Dim Count, i As Long Dim MySheet As Worksheet Count = 0 Set MySheet = Sheets(MyRange.Parent.Name) If ColRef = 0 Then ColRef = MyRange.Columns.Count For i = MyRange.Row To MyRange.Row + MyRange.Rows.Count - 1 If MySheet.Cells(i, MyRange.Column).Value = MyVal Then Count = Count + 1 If Count = Nth Then VlookupNth = MySheet.Cells(i, MyRange.Column + ColRef - 1).Value Exit Function End If End If Next i VlookupNth = "" End Function</pre>
