•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to create an if then or if then for a drop down menu
Our take
Creating an interactive dropdown menu in Excel can be a game-changer for your data management. By setting up an "if-then" function, you can ensure that selecting an item, such as "160×60" or "160×50," will automatically display corresponding text in another cell, like "4 wheel unit" or "6 wheel unit." Additionally, you can populate a cell with today’s date to keep your data organized and current. Let’s simplify this process together and empower your spreadsheet skills for more efficient workflows. Cheers!
It's been a good while since i have used excel. I'm trying to create a sheet where if you select an item say 160×60 or 160×50 then it will bring up text in another cell say 4 wheel unit or 6 wheel unit and also populate a cell with today's date. I've been trying all morning, but my brains collapsed.
Cheers in advance
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#financial modeling with spreadsheets#natural language processing for spreadsheets#generative AI for data analysis#excel#if then#dropdown menu#cell#populate#text#160×60#160×50#sheet#4 wheel unit#6 wheel unit#selected item#date