title: How to randomly select cell and the adjacent cell on excel
body: <p>I am trying to find a formula on excel that will allow me to randomly select a cell between a range (this part I have found a formula for) and have the value pasted into another cell AND then have the cell next to the randomly selected cell's value also selected and pasted into a different cell. </p>
  
  <p>Not sure if this makes sense so I will explain what I'm trying to do. </p>
  
  <p>I have a column full of years and the adjacent column full of prices that correspond to each year. I want a year randomly selected and pasted into a cell lower down on the spreadsheet, and I want the corresponding price for this randomly selected year pasted next to this cell. </p>
  
  <p>Thank you in advance! </p>
  
  <p>Anna</p>