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 the...
Twifoo
Jun 15, 2019Silver Contributor
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)
=VLOOKUP(A2,
TitleAuthors,
2,0)