title: How do I reference the cell to the left of the current cell in Google sheets?
body: <p>I have to apply a function to every cell in column 2, which retrieves information about a symbol in column 1. I have 100 columns and don't want to individually plug each symbol in, so I need a way to reference the information in A2 in the function being used in B2</p>
  
  <p>E.g.
  <a href="https://i.stack.imgur.com/wU38G.png" rel="noreferrer">This is the spreadsheet I'm working on.</a></p>
  
  <p>=GOOGLEFINANCE(<strong>SymbolDisplayedInTheCellToTheLeftOfThisCell</strong>, "price")</p>
  
  <p>Thanks </p>