Home

Fill in data next to drop-down box

%3CLINGO-SUB%20id%3D%22lingo-sub-693214%22%20slang%3D%22en-US%22%3EFill%20in%20data%20next%20to%20drop-down%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-693214%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20create%20a%20spreadsheet%20to%20consolidate%20research%20findings.%20I've%20listed%20the%20sources%20in%20one%20column%20and%20the%20authors%20in%20a%20second.%20For%20several%20reasons%2C%20I%20need%20the%20two%20to%20display%20in%20their%20own%20columns.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20set%20up%20data%20validation%20with%20a%20drop%20box%20for%20titles%2C%20and%20it%20works%20fine.%20What%20I%20would%20like%20to%20do%20is%20have%20the%20cell%20adjacent%20to%20the%20right%20pull%20up%20the%20author%20information%20that%20correlates%20to%20the%20title.%20The%20data%20is%20in%20two%20columns%20on%20a%20separate%20sheet%20in%20the%20same%20workbook.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-693214%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-693928%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20in%20data%20next%20to%20drop-down%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-693928%22%20slang%3D%22en-US%22%3EName%20the%202%20columns%20of%20your%20data%20as%20%E2%80%9CTitleAuthors%E2%80%9D.%20If%20the%20drop-down%20list%20for%20titles%20is%20in%20A2%2C%20enter%20this%20formula%20in%20B2%3A%3CBR%20%2F%3E%3DVLOOKUP(A2%2C%3CBR%20%2F%3ETitleAuthors%2C%3CBR%20%2F%3E2%2C0)%3C%2FLINGO-BODY%3E
Jeatonm
Occasional Visitor
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)
Related Conversations