title: Combine a constant column with a variable row
body: <p>For the sake of simplifying what I'm doing, we'll just say that in one of my cells, I'm calculating the slope of a range. For reference, let's say that in cell C1 I have <code>=SLOPE(A:A,B:B)</code>. Fairly simple - however, what I really want to do is have my slope only look at values up to a certain row, starting at row 2. For example, <code>=SLOPE(A2:Ax,B2:Bx)</code> where. <code>x</code> is a variable based on the value of a cell that I have already calculated.</p>
  
  <p>Let's say <code>x</code> is located in cell G20, and the value of G20 is <code>59</code>. If this is the case, I want my slope function to be <code>=SLOPE(A2:A59,B2:B59)</code>. However, based on the formula I have in G20, its value will change based on user input. So G20 can change to <code>61</code>, <code>62</code>, or <code>63</code>, etc., and when that happens, I want that to be reflected in my SLOPE formula. If G20 changes to <code>60</code>, then C1 should become =<code>SLOPE(A2:A60,B2:B60)</code>. If G20 becomes <code>61</code>, then C1 should become <code>=SLOPE(A2:61,B2:B61)</code>. And so on and so on....</p>
  
  <p>I'm simplifying what I'm really doing for the sake of example, so try not to think about an easier way to do this. I just need to combine a constant column value with a variable row value, and stick that into a formula.</p>
  
  <p>How can I go about doing this?</p>