How to Create Drop down List With Auto Price List Excel 2020 | Data Validation | Excel | covid 19
HTML-код
- Опубликовано: 24 апр 2020
- #data_validation#auto_price#excel
In this video I'm going to show you how to create a dynamic dropdown list in excel & How to Create an automatic price list in your excel spreadsheet. Also using the data validation options and some excel formulas for creating the daily sales report.
Formulas (office 2003,07,10,13,16 Same)
1. Dynamic Dropdown List : =INDIRECT("TABLE1")
2. Auto price list : =IFERROR(VLOOKUP(D4,'PRODUCT LIST'!A:B,2,FALSE)," ") Keyboard Command (Windows)
1. Past Name : F3
2. Auto Date : Ctrl+;
3. Auto Time : Ctrl+Shift+:
If you have any question, feel free to ask me in the comment section. I will be more than happy to reply you!
" Shohoz Life " is a tech & tutorial base channel.
Thanks for watching.
Like comment and share this video with your friends. Please don't forget to subscribe to my channel :)
RUclips link: bit.ly/2VLFyG3
Find Us - Facebook: / shohozlifee
Linkedin / shohozlifee
Twitter: / shohozl
Thank You So Much!
About this Channel: We are a team of people working together as Shohozlife channel. Some of us are working as Digital Marketing trainers, Executives and Strategists, etc. Here we are trying to cover almost every online digital marketing and other exam guidelines.
Disclaimer: The information available on this RUclips channel is for educational and information purposes only. We have shared here Google, Facebook, Twitter, SEMrush, HubSpot, Microsoft, and more exam guidelines with our viewers for free. In the shohozlife, we have made it our mission to transform the skills and knowledge of digital professionals on a global scale for only learning purposes. Feel free to request for any other exam guidelines.
" Shohoz Life " is a tech & tutorial base channel.
Like comment and share this video with your friends.
Please don't forget to subscribe to my channel :) bit.ly/2Hvd4cv
Thank You Soooo Much...!
Regards: Shohoz Life Team.
#data_validation#auto_price#excel - Хобби
Thanks for watching.
Like comment and share this video with your friends. Please don't forget to subscribe to my channel :)
RUclips link: bit.ly/2VLFyG3
Find Us - Facebook: facebook.com/shohozlifee
Linkedin www.linkedin.com/shohozlifee
Twitter: twitter.com/ShohozL
Thank You So Much!
krdia hy bhai very informative video 😇
Can you please explain more about the VLOOKUP step you made?
i was trying on google sheets its different but man from your video i got an idea how to do things plus i used my brain Thanks man
You are most welcome
On you tube after one and half an hour, i found your videos. It really makes my life easy.
Great work. Been looking for this for so long! Thanks a lot.
Thank you! I spent hours before trying to follow other videos and now you made it so simple.
One thing I would add though is =if(isblank(e2)," ",vlookup ect..... now my project can come to life. Many thanks
Just what I was looking for ty 👍
Apnr jonno onek onek dowa roiylo
আপনার জন্য ও, অনেক ধন্যবাদ
Needed this reminder ! Excellent tutorial 🙏
thanks a lot its wonderfully works out
Wonderful work, I totally forgot about the vlookup function🙏
Very helpful. Thank you
You are welcome
Thank you for this!
অসাধারণ কাজ
Thank you so much
you make my life easy
bro
Very useful video. Thanks a lot.
This is really good
Very helpful!! thank you! I couldn't figure out how to create the second conditional column - turns out vlookup was the key. Thank you!!
You are most welcome.
Thank you so much bro
Nice, very precious elements to learn
Onk sundor
What happens when the Rate changes in future. When i change the rate for an item in the Control table, how do i protect previous entries from being updated with the new rate?
Its a very helpful video
i dint get the vlookup(E2,table1,2,0) how to get that formula,
Excellent tutorial
Thanks for sharing
Very helpful video 🙂
Thanks again
U are welcome
Thank you so much
You are most welcome
THANKS LOTS
Great video
fantastica
Vlo laglo
Great
Thank u sm
Excillent
Thank you
bro need same thing which one you created now but without table how we can make this formula in same cells please guide me thanks
why table1,2,0?
Table 1 refers to the list of fruit he created on the right side of the sheet. He turned the list into a table which the software named “Table 1” by default. 2 is answering the question “Which column?” You’re saying I want the data from Table 1 in column 2 (to draw out the corresponding data for RATE).
@@iREZARECTEM what about the "0" that comes after the 2. What does that refer to?
@@tylerbird876, 0 is the attribute the author assigned for the “[range_lookup]”. Enter 0 or FALSE for an exact match.
Meaning it only pulls up exact matches. 1 or True for Approximate matches (which is not recommended for this example, and you probably won’t have a reason to use approximate matches very often.
because i dont need table this with formula, it is work but when i remove table it does not work
i want table entries from another sheet !
Make your list on a seperate sheet and follow same procedure. I have my list in sheet 2, i was able to add more coloumns as well so now when i select item from dropdown i get price and unit autofilled. Just replace the 2 in Table1,2,0 with whatever coloumn you want. Eg. Table1,3,0 gives me unit
@@PajamaPants10102 my table is on sheet one and my drop down list is on sheet 2. How to enter the vlookup function if your table is on sheet 1
@@lindsyjeanpalabrica-xc7vl You just have to enter the vlookup in the cell you want on Sheet 2 and select the Table from Sheet 1. *When you start typing the title of your table in the vlookup, it should show up, eg mine is named Table 1*
what is num range and look up ? pls help :(
In a huge dropdown list how can find easily the item..
Maybe Sort your list alphabetically
again & again disturbing the subcription ad...by sound & its appearnce on screen is so much disturbing while watching the video. it divirts ther mind when appear suddenly with horror sound
Sk easy
2 much bs in this tutorial