I manage a google spreadsheet for a video game I follow that contains lists of different items you can get in the game.
I'll try to explain this next part to the best of my ability.
With these items, I created a "Build Maker" which uses the items to allow people to put together a build that they would want to do in the video game itself.
I have done this by using drop-down lists and VLOOKUP formulas. This part works great, however, I want it so that when you change the class, it changes the data in the drop-down lists to the ones from other sheets. Link for video for better explanation (can't post link): https://imgur.com/a/YCnQCtV
I'm not a google sheets pro and I do not code/program so if someone could explain in detail how I could make this work, it would be very much appreciated.
Bookmarks