Fill in data next to drop-down box

Copper Contributor
Hello,

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.

Thank you
1 Reply
Name the 2 columns of your data as “TitleAuthors”. If the drop-down list for titles is in A2, enter this formula in B2:
=VLOOKUP(A2,
TitleAuthors,
2,0)