title: Google Spreadsheet - Populate a cell based off different cells content, and use a third cells value
body: <p>Is it possible to fill a cell with data from another cell based off the content of a different cell? I have a drop down menu in one cell, and when I select something from that menu, I would like the cell next to it to search a database on that sheet that the drop down is based off of. it has a second row with different values I would like to appear in the next column. I think about it, and it should seem easy, but I'm having troubles explaining it.</p>