title: Excel dropdown list - automatically fill in values based on selection
body: <p>I am trying to create an internal costing spreadsheet for a restaurant. I've reacquainted myself with how to create dropdown lists (used, in this case, for selecting ingredients).</p>
  
  <p>When someone selects e.g. 'carrots' from the dropdown list, I would like other fields to autopopulate with costing data from another spreadsheet. I know how to make the dropdown pull data from the other sheet, but I do not know how to then have fields on the current sheet pull costing data conditionally based on which item in the dropdown is selected.</p>
  
  <p>Please explain the answer like I'm 5; it's been many years since my Excel ninja days.</p>
  
  <p>TIA</p>