title: IF formula to display a range of cells
body: <p>If I have an Excel workbook with four sheets where:</p>
  
  <p>Sheet 1 will be used by a user<br>
  Sheets 2-4 will be hidden for raw data. </p>
  
  <p>and I have used data validation to create a drop down for uses to be able to select searchable criteria, how do I display a range of cells from the raw data based upon their selection?</p>
  
  <p>Eg. If user selects 1, it would show all data from cells A1-C35, Sheet 3. If they selected 2, it would show all data from cells A14-C46, Sheet 3. Etc etc.</p>