Thanks for watching. Like comment and share this video with your friends. Please don't forget to subscribe to my channel :) UA-cam link: bit.ly/2VLFyG3 Find Us - Facebook: facebook.com/shohozlifee Linkedin www.linkedin.com/shohozlifee Twitter: twitter.com/ShohozL Thank You So Much!
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
hi! the video is great and very helpful. Is there a way that i can take my new worksheet and have my employees use it in their day to day and not see the tables created?
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?
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
@@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*
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).
@@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.
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
Thanks for watching.
Like comment and share this video with your friends. Please don't forget to subscribe to my channel :)
UA-cam 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?
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
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
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.
Needed this reminder ! Excellent tutorial 🙏
Apnr jonno onek onek dowa roiylo
আপনার জন্য ও, অনেক ধন্যবাদ
hi! the video is great and very helpful. Is there a way that i can take my new worksheet and have my employees use it in their day to day and not see the tables created?
Wonderful work, I totally forgot about the vlookup function🙏
Just what I was looking for ty 👍
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?
Very useful video. Thanks a lot.
you make my life easy
bro
Nice, very precious elements to learn
thanks a lot its wonderfully works out
Very helpful. Thank you
You are welcome
অসাধারণ কাজ
Thank you so much
Its a very helpful video
Excellent tutorial
Onk sundor
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
Very helpful video 🙂
Thank you for this!
Thank you so much bro
Thanks for sharing
Great video
This is really good
i dint get the vlookup(E2,table1,2,0) how to get that formula,
Thanks again
U are welcome
fantastica
Vlo laglo
Thank you so much
You are most welcome
Excillent
because i dont need table this with formula, it is work but when i remove table it does not work
what is num range and look up ? pls help :(
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*
In a huge dropdown list how can find easily the item..
Maybe Sort your list alphabetically
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.
THANKS LOTS
Thank u sm
Thank you
bestest
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
Unwanted sound and irritating so avoid sound
2 much bs in this tutorial
Your sound engineer needs to be arrested this is hideous