Posts by stormycrane16

Kyle Johnson2 said:Just set up a Drop-down menu to act as your criteria and then lean on the VLOOKUP function in Excel. Honestly, you’d make your life so much easier if you just gave that data range a proper name—it makes working with all those formulas way less of a headache.

So, I went ahead and tried out those functions and it technically works, but it's still acting a bit funky in certain spots 🙂... I've attached the file here, so if you have a spare second to take a look, I'd really appreciate it.. thanks!

Code:

So, I’m looking to set up a little dropdown menu in one of my fields that holds a bunch of different items. Ideally, once I pick an item from the list, I want the computer to just... I don't know, do its thing and automatically fill in the unit of measurement and the price for me? Is that actually doable, or am I just dreaming? If anyone could point me in the right direction or help me pull this off, I’d really appreciate it. Thanks in advance!