title: Active cell as input to formula
body: <p>I was wondering if I can use the active cell, by that I mean the cell that is "highlighted" at a given time with the square border after there was a mouse click there, as an argument in a function.</p>
  
  <p>For example, I have created a table with weighted averages with 3 weights: w1 is given in the column headers (kindly see the file below), w2 in the row headers, and w3 which complements w1 and w2 to 1.</p>
  
  <p>What I'd like to do is have cells outside the table show the weights the average got when a cell in the table is selected.</p>
  
  <p>For example:
  Screenshot: <a href="http://imgur.com/emmBH5S/" rel="noreferrer">http://imgur.com/emmBH5S/</a></p>
  
  <p>file can be found here: <a href="https://drive.google.com/file/d/0B_7-00fdslR7Tm11ODRVS296ckk/" rel="noreferrer">https://drive.google.com/file/d/0B_7-00fdslR7Tm11ODRVS296ckk/</a></p>
  
  <p>Here we see the cell K12 is active,
  and for K12 w1=0.2, w2=0.15, and so, the cells in the weights tables above (rows 3-4) get the appropriate values according to the weights in the active cell.
  (of course I manually created this one for illustration purposes)</p>
  
  <p>Is there a way to do that? Preferably without VBA if possible 
  Couldn't find anything very useful...</p>
  
  <p>Thanks in advance!
  A </p>