Forum Discussion
Jeatonm
Jun 14, 2019Copper Contributor
Fill in data next to drop-down box
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
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
- TwifooSilver ContributorName 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)