title: Getting rid of #REF! errors on a dropdown list
body: <p>I have a google sheet with the following format</p>
  
  <p>Column A - Names</p>
  
  <p>Column B - Product</p>
  
  <p>Column C - Amount of product</p>
  
  <p>Column D - Town</p>
  
  <p>Column E - Formula (=rows($D$2;D168) this gets me a number in order.</p>
  
  <p>Column F - Formula (=if(sheet2!$D$2=B2,E2,"")</p>
  
  <p>Column G - Formula (=iferror(small($F$2:F2)),"")</p>
  
  <p>There are 180 names in the list and maybe more later </p>
  
  <p>and i have this in one sheet and on the second sheet have the following format</p>
  
  <p>Column B - list of product names in sorted order
  Column D - Dropbox with the product name.</p>
  
  <p>Column F - Client name {Formula =iferror(index(Sheet1!$A$2:$D$182,Sheet1!$G4,columns(Sheet1!$A$2:A2)),"")</p>
  
  <p>Column G - Column I has the same formula in it.</p>
  
  <p>When i click on the dropdown it does put the information in sheet 2, but if there is only prints the info of that selection and if there is no more info i get #REF! in the other boxes, is there any way of getting rid of this error please?</p>