View Single Post
  #1   Report Post  
Marc Todd
 
Posts: n/a
Default Eliminate creating list that returns blank cells

I am trying to create a new range that returns data from columns of an
existing range without creating a list of blank cells. I used VLOOKUP but
may have used it incorrectly as I changed the seach parameters in each
descending cell in the column. Which function/formula do I use to return
lookup data without creating a list filled with blank cells?