title: Google Spreadsheet Formula to get last value in a row
body: <p>I wondered if someone could help me with what I hope is a simple Formula. </p>
  
  <p>I have a simple spreadsheet for Product which has a column for the product name eg</p>
  
  <p>Product A</p>
  
  <p>Product B</p>
  
  <p>Product C</p>
  
  <p>Product D</p>
  
  <p>Now on each row there are some numerical values </p>
  
  <p>eg</p>
  
  <p><strong>Product</strong></p>
  
  <p>Product A   5.0 2.5</p>
  
  <p>Product B   6.0</p>
  
  <p>Product C   2.0 4.0 5.0</p>
  
  <p>Product D   3.0</p>
  
  <p>Product E 6.0  2.0  1.6  2.9</p>
  
  <p>Now what I want is to have a formula for a Column next to the prouct  that shows me the value of the last entered value for a Product eg 
  the Values in the above example would give me</p>
  
  <p>Product A 2.5</p>
  
  <p>Product B 6.0</p>
  
  <p>Product C 5.0</p>
  
  <p>Product D 3.0</p>
  
  <p>Product E 2.9</p>
  
  <p>In Excel I would do this with INDEX and MATCH however I cannot get this to work in Google Spreadsheets.</p>
  
  <p>Any ideas would be most welcome.</p>
  
  <p>Here is a screenshot of what I would like it to look like.
  <a href="https://i.imgur.com/jqcNW.png" rel="noreferrer">http://i.imgur.com/jqcNW.png</a></p>
  
  <p>Many thanks in advance</p>