Drop down lists are created with the input data that also resides in the workbook. While in most cases we may want the drop down items to look exactly the same as the input range, in some cases you may want it to look different.
For example, you may want 1 to look TRUE and 0 to look FALSE.
In this video tutorial, I will show you a trick to do this. You will learn how to create a drop-down list in Excel that displays desired text, but when selected, returns a number
Read More:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Please how can we do this with decimal number?
This method doesn't work for multiple numbers in a dropdown
This is Genius! Thank You! I was looking for this and could not find anything.
what if you have the same number twice but it means different things
This is genius, but I am wanting to do It for my Rota, is there a way to have something that says "finish" but its calculated as 21:30? Everytime i try it seems to translate it as 0.895833333333333 🙁
Is there a way disguise multiple numbers in the same dropdown list? For example, you want to disguise all 5 numbers to show text in the same dropdown?
Is there a way disguise multiple numbers in the same dropdown list? For example, you want to disguise all 5 numbers to show text in the same dropdown?
Very well done sir. I've been looking for this info for half an hour and your video was short and simple. Subscribed.
is there a way to have text in a drop down represent a symbol? for example, my drop down would have the option "yes" and when I select it, a check mark symbol would appear in the cell.
VIDEO IS NOT WORKING. CAN YOU PLEASE FIX. I AM DETERMINED TO FIGURE THIS OUT. THANK YOU!
very astute trick…you are awesome!!
You are awesome! I am going to impress my boss with this. Keep up the good work!
Nice one, but it doesn't work when you have few values in the cell like "18, 67, 24" Do you have any tip for this?