title: INDEX / MATCH / VLOOKUP Assistance
body: <p>The below table is the first 29 rows in an XLSX I'm working on, which basically aims to calculate the costs of exported call data.</p>
  <p>The data in the table below is the result of population from a PowerShell script, which combines Rate Data from a CSV (to calculate call charges) with Call Data from the customer's daily call stats in another CSV.</p>
  <p><strong>Rate Data:</strong></p>
  <p>Column F [Destination] contains every known Country Code.
  Column E [Rate] contains a Rate value for each Country Code in column F, which will be used to calculate the call cost at the end.</p>
  <p><strong>Call Export Data:</strong>
  Column C [Callee Number] contains the original phone number that was called (Callee).
  Column H [Callee Country Code] takes first few digits of the number in Column C for the next step.</p>
  <p><strong>Required goal that I'm quite frankly stuck on:</strong></p>
  <p>Column I is what I'm working on.</p>
  <p>I need a formula that effectively looks for the dialled country code in Column H and looks for the country code that's the MOST SIMILAR to it (Doesn't need to be exact) in Column F. Once found, I need it to return the value on the same row, in Column E [Rate].</p>
  <p>Column I should then be populated with the correct Rate for the Number in Column C / H.</p>
  <p>Formula's I've tried:</p>
  <p><code>=INDEX($A$2:$K$100000,VLOOKUP(H2,$F$2:$F$100000,5,TRUE))</code></p>
  <p><code>=INDEX($G$2:$G$100000,MATCH(H2,$F$2:$F$100000,0))</code></p>
  <p>I'm not great with Excel but and I'm sure using 100000 to select the whole column is poor practise.</p>
  <p>Thanks for any help :)</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Start time</th>
  <th>Customer</th>
  <th>Callee Number</th>
  <th>Country</th>
  <th>Rate</th>
  <th>Destination</th>
  <th>Duration (Minutes)</th>
  <th>Callee Country Code</th>
  <th>Rate for call</th>
  <th>Cost of call</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2020-09-01T07:25:30.5190000Z</td>
  <td>Name1</td>
  <td>+44***</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>93</td>
  <td>0</td>
  <td>44</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T08:05:52.6250000Z</td>
  <td>Name2</td>
  <td>+442476******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9320</td>
  <td>0.383333333</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T08:33:49.6530000Z</td>
  <td>Name3</td>
  <td>+441509******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9321</td>
  <td>0.7</td>
  <td>441</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T08:35:18.5300000Z</td>
  <td>Name4</td>
  <td>+441509******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9322</td>
  <td>0.766666667</td>
  <td>441</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T08:43:45.3300000Z</td>
  <td>Name5</td>
  <td>+447976******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9323</td>
  <td>1.85</td>
  <td>447</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T08:47:29.9630000Z</td>
  <td>Name6</td>
  <td>+442476******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9324</td>
  <td>2.533333333</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T08:57:43.2680000Z</td>
  <td>Name7</td>
  <td>+447875******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9325</td>
  <td>3.633333333</td>
  <td>447</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T09:04:42.8230000Z</td>
  <td>Name8</td>
  <td>+441212******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9326</td>
  <td>4.916666667</td>
  <td>441</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T09:15:32.7220000Z</td>
  <td>Name9</td>
  <td>+441923******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9327</td>
  <td>1.9</td>
  <td>441</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T09:30:36.4750000Z</td>
  <td>Name10</td>
  <td>+441923******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9328</td>
  <td>5.8</td>
  <td>441</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T09:58:12.8380000Z</td>
  <td>Name11</td>
  <td>+442476******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9370</td>
  <td>0.516666667</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T10:03:04.1270000Z</td>
  <td>Name12</td>
  <td>+442476******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9375</td>
  <td>13.51666667</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T10:27:49.6090000Z</td>
  <td>Name13</td>
  <td>+442476******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9377</td>
  <td>2.716666667</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T11:04:21.7850000Z</td>
  <td>Name14</td>
  <td>+442476******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9378</td>
  <td>1.6</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T11:13:31.9810000Z</td>
  <td>Name15</td>
  <td>+442070******</td>
  <td>AFGHANISTAN</td>
  <td>1.415</td>
  <td>9379</td>
  <td>9.816666667</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T11:46:53.4730000Z</td>
  <td>Name16</td>
  <td>+442476******</td>
  <td>ALAND ISLANDS</td>
  <td></td>
  <td>247</td>
  <td>0.283333333</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T11:47:14.9110000Z</td>
  <td>Name17</td>
  <td>+442476******</td>
  <td>ALBANIA</td>
  <td>0.537</td>
  <td>355</td>
  <td>0.866666667</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T12:30:38.4380000Z</td>
  <td>Name18</td>
  <td>+442476******</td>
  <td>ALBANIA</td>
  <td>0.537</td>
  <td>3554</td>
  <td>0.25</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T12:30:59.5190000Z</td>
  <td>Name19</td>
  <td>+442476******</td>
  <td>ALBANIA</td>
  <td>0.537</td>
  <td>35567</td>
  <td>0.283333333</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T12:31:34.3300000Z</td>
  <td>Name20</td>
  <td>+442476******</td>
  <td>ALBANIA</td>
  <td>0.537</td>
  <td>35568</td>
  <td>0.283333333</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T12:35:20.8430000Z</td>
  <td>Name21</td>
  <td>+442476******</td>
  <td>ALBANIA</td>
  <td>0.537</td>
  <td>35569</td>
  <td>0.3</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T12:37:36.5550000Z</td>
  <td>Name22</td>
  <td>+442476******</td>
  <td>ALGERIA</td>
  <td>0.537</td>
  <td>213</td>
  <td>1.366666667</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T12:42:07.9660000Z</td>
  <td>Name23</td>
  <td>+447723******</td>
  <td>ALGERIA</td>
  <td>0.537</td>
  <td>21321</td>
  <td>1.466666667</td>
  <td>447</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T13:13:37.7610000Z</td>
  <td>Name24</td>
  <td>+441926******</td>
  <td>ALGERIA</td>
  <td>0.537</td>
  <td>21355</td>
  <td>3.283333333</td>
  <td>441</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T13:44:57.3190000Z</td>
  <td>Name25</td>
  <td>+442476******</td>
  <td>ALGERIA</td>
  <td>0.537</td>
  <td>21356</td>
  <td>0.15</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T13:46:39.2640000Z</td>
  <td>Name26</td>
  <td>+442476******</td>
  <td>ALGERIA</td>
  <td>0.537</td>
  <td>21366</td>
  <td>0.15</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T13:58:14.1340000Z</td>
  <td>Name27</td>
  <td>+442476******</td>
  <td>ALGERIA</td>
  <td>0.537</td>
  <td>21369</td>
  <td>6.2</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2020-09-01T13:58:30.5560000Z</td>
  <td>Name28</td>
  <td>+442476******</td>
  <td>ALGERIA</td>
  <td>0.537</td>
  <td>21377</td>
  <td>0.583333333</td>
  <td>442</td>
  <td></td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div>