title: Updating cell data based on dropdown list in Google Sheets
body: <p>This is probably a silly question but I have looked around for a while now and I'm not finding exactly what I need. </p>
  
  <p>In sheet 2, I have a list of items down column A. Then I have text next to those items in column B. Text in B3 is only related to A3 etc. </p>
  
  <p>I have a dropdown list of all column A item names on sheet1 and I'd like a cell somewhere on this sheet to display the corresponding info/text depending on whatever item I chose from the dropdown list. </p>
  
  <p>For example, if I had small stories that would pop up depending on the title of the story - I'd select "Red Riding Hood" from the drop down list and then the short story would populate into a designated cell. </p>
  
  <p>I feel like this should be pretty straight forward but I couldn't find the right formula. Thank you for your help. </p>