Forum Discussion

Jeatonm's avatar
Jeatonm
Copper Contributor
Jun 14, 2019

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

1 Reply

  • Twifoo's avatar
    Twifoo
    Silver 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)

Resources