title: How to pull "market capitalization” data from Yahoo! Finance within Excel?
body: <p>How to pull "market capitalization” data from Yahoo! Finance within Excel?</p>
  
  <p>i get #value error...  i get the same error when i try to get j1, j3 or r1.<a href="https://i.stack.imgur.com/6x0wN.png" rel="nofollow noreferrer">See attached error and formula</a></p>