I am trying to create a spreadsheet to consolidate research findings. I've listed the sources in one column and the authors in a second. For several reasons, I need the two to display in their own columns.
I have set up data validation with a drop box for titles, and it works fine. What I would like to do is have the cell adjacent to the right pull up the author information that correlates to the title. The data is in two columns on a separate sheet in the same workbook.