SOLVED
Home

Help creating a VERY big dropdown/vlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-735000%22%20slang%3D%22en-US%22%3EHelp%20creating%20a%20VERY%20big%20dropdown%2Fvlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735000%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3ESo%20I've%20recently%20started%20creating%20a%20video%20game%20%22guide%22%20on%20excel%20as%20a%20little%20side%20project.%20I%20wanted%20to%20make%20this%20one%20table%20that%20included%20all%20of%20the%20villager's%20gift%20opinions%2C%20but%20it%20was%20getting%20bigger%20and%20bigger%20with%20each%20villager%20added%2C%20and%20just%20all%20round%20seemed%20messy%2Fhard%20to%20read.%20I%20thought%20about%20creating%20a%20drop%20down%20list%20that%20held%20all%20of%20the%20villager%20names%20and%2C%20when%20one%20was%20chosen%2C%20showed%20the%20different%20options%20for%20the%20villager%2C%20but%20it's%20been%20proving%20VERY%20difficult%20for%20me%20to%20wrap%20my%20head%20around.%3C%2FP%3E%3CP%3EIs%20it%20actually%20possible%20to%20achieve%20what%20I'm%20aiming%20for%20or%20should%20I%20just%20create%20different%20tables%20for%20each%20villager%3F%20I've%20attached%20a%20screenshot%20of%20the%20current%20table%20I'm%20working%20on%2C%20and%20what%20I%20wanted%20to%20achieve.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-735000%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735022%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20creating%20a%20VERY%20big%20dropdown%2Fvlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735022%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370100%22%20target%3D%22_blank%22%3E%40cat_hobbo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20guess%20you%20want%20to%20create%20a%20searchable%20drop%20list.%20May%20be%20also%20dependent%20drop%20lists.%3C%2FP%3E%3CP%3EHere%20is%20a%20link%20to%20one%20of%20my%20tutorials%20on%20How%20to%20create%20a%20searchable%20drop%20list.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D8gqodEiDoJ8%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D8gqodEiDoJ8%3C%2FA%3E%3C%2FP%3E%3CP%3Ehere%20is%20a%20link%20to%20my%20tutorial%20on%20How%20to%20create%20Dependent%20Drop%20lists%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D0MuQfUJbycQ%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D0MuQfUJbycQ%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
cat_hobbo
Occasional Visitor

Hi!

So I've recently started creating a video game "guide" on excel as a little side project. I wanted to make this one table that included all of the villager's gift opinions, but it was getting bigger and bigger with each villager added, and just all round seemed messy/hard to read. I thought about creating a drop down list that held all of the villager names and, when one was chosen, showed the different options for the villager, but it's been proving VERY difficult for me to wrap my head around.

Is it actually possible to achieve what I'm aiming for or should I just create different tables for each villager? I've attached a screenshot of the current table I'm working on, and what I wanted to achieve.

1 Reply
Highlighted
Solution

@cat_hobbo 

Hi

I guess you want to create a searchable drop list. May be also dependent drop lists.

Here is a link to one of my tutorials on How to create a searchable drop list.

https://www.youtube.com/watch?v=8gqodEiDoJ8

here is a link to my tutorial on How to create Dependent Drop lists:

https://www.youtube.com/watch?v=0MuQfUJbycQ

 

Hope that helps

Nabil Mourad

Creating dependent drop lists. Using drop lists in Excel creates a dynamic professional worksheet. In a previous tutorial I explained how to create a drop list "Data Validation". In this tutorial we'll go one step farther by creating 2 drop lists where the contents of the second drop list change ...
A Drop Down List is extremely useful in Excel. However, If we have hundreds of values it becomes difficult to find the specific value we are looking for. In this tutorial you'll learn how to shrink your list to fewer options by typing few characters and your drop down list will show only options ...
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies