title: Random Numbers to select from two tables in Excel
body: <p>I would like to randomly select a number from two tables in excel, however when I use the RAND() OR RANDBETWEEN() function it does not work . The tables are as follows. </p>
  
  <p><strong>Table One:</strong></p>
  
  <p><strong>Year       Cost</strong><br>
  1    £700,000.00</p>
  
  <p>2    £717,500.00</p>
  
  <p>3    £735,437.50 </p>
  
  <p>4    £753,823.44</p>
  
  <p>5    £772,669.02 </p>
  
  <p>6    £791,985.75</p>
  
  <p>7    £811,785.39 </p>
  
  <p>8    £832,080.03</p>
  
  <p>9    £852,882.03 </p>
  
  <p>10   £874,204.08 </p>
  
  <p><strong>Table 2:</strong></p>
  
  <p><strong>Year      Cost</strong></p>
  
  <p>3    £800,000.00 </p>
  
  <p>4    £828,000.00 </p>
  
  <p>5    £856,980.00</p>
  
  <p>6    £886,974.30</p>
  
  <p>7    £918,018.40</p>
  
  <p>8    £950,149.04 </p>
  
  <p>9    £983,404.26</p>
  
  <p>10   £1,017,823.41 </p>
  
  <p>11   £1,053,447.23 </p>
  
  <p>12   £1,090,317.88 </p>