Best way to start my morning :) watching your video with a cup of coffee! Love how you've emphasized all the advantages of LOOKUP here - it really is an amazing function that I myself keep forgetting about. Thank you for this series. I'm looking forward to the next ones.
Great sir! Thank u so much for explaining every detail though still I need to study it hard. I have the similar table in product table but my price column has 3 lookups which (0-2), (3-6), (7 or more) - refering to the quantity being ordered. Furthermore, i have order table and order detail table. In order table i have only the general info like order date, customer, agent, shipper, total amount. In order detail table has orderdetail ID, order id (foreign key to order table), product, quantity, price (to be generated from product lookup table), and line total. I am very grateful to watch your videos and excited to learn more from those. Keep it up! More powers.
Glad it was awesome for you, Chris! The next five videos will be a lot of fun with many different solutions and many different formula tricks! Thanks for your support : )
Very interesting video! Since I have no problem with helper columns, I made one in A11 that's =B11&C1 etc, sorted it and then looked up the price with =VLOOKUP(D22&C22,$A$11:$D$17,4).
I had it in my head that the lookup function had been superseded by the vlookup predominantly, and to a lesser scale by the hlookup. Now I have to reevaluate my thoughts Mike. Feeling confused, but only a bit. Top excel trick, by the master excel teach.
Glad you like the trick, John!! I am not sure what you meant when you wrote "the lookup function had been superseded by the VLOOKUP predominantly, and to a lesser scale by the hlookup". Can you explain more about what you meant? LOOKUP was THE first spreadsheet function in the original 25 functions in Visi Calc. VLOOKUP and HLOOKUP with the ability to do either Approximate Match or Exact Match lookup came later...
Well, I have seen videos and used the vlookup quite often, and it is a brilliant function. I have also, to a lesser degree seen videos on hlookup, and I have also had occasions to use hlookup, but to a far lesser degree. Now, I knew lookup was there, but until an hour ago, I never seen any videos on the function, and I had never looked at it at all. Therefore. I just thought it was brought out in an early package, but was then replaced/superseded by the v and h lookups. Now I need a rethink, as the lookup function can do operations exclusive to the other two? That is a question Mike.
Hello Mike, I enjoyed your videos thoroughly. Thank your very much for sharing such valuable material with us. But there is one thing I don't understand and would like to ask you this question. In this formula =LOOKUP(2,1/(($B$11:$B$17=D22)*($C$11:$C$17
When lookup functions do Approximate Match Lookup and the lookup value is bigger than anything in the lookup column, the function always returns the last item. LOOKUP, VLOOKUP, HLOOKUP, MATCH all have this Approximate Match lookup behavior. When you intentionally give a lookup function a lookup value that is bigger than any value it can find, this is called the "Big Number Lookup to get last item" concept.
I have one question which I want to send you can please give me your mail id or other id where I can upload or send my question excel sheet please helpme
Best way to start my morning :) watching your video with a cup of coffee! Love how you've emphasized all the advantages of LOOKUP here - it really is an amazing function that I myself keep forgetting about. Thank you for this series. I'm looking forward to the next ones.
Yes, coffee and Excel go together in the early morning quite well, when we have LOOKUP too, it is even better : ) You are welcome as always, Teammate!
@@excelisfun you and Leila and recently Mynda are my Favorite excel channels
@@shakiraasfoor7599 I am very glad to help, and I appreciate your support!
Thanks Mike. I couldn't resist trying the Index-Match formula instead =INDEX($C$11:$D$17,MATCH(2,1/(($B$11:$B$17=D22)*($C$11:$C$17
Awesome formula! The last one in this series will be a different INDEX & MATCH : ) So much fun on our Online Excel Team using Excel!!
Super sir this is satish from learn more channel
Glad it was super for you, Satish!!! Thank you for your support, Online Excel Teammate!!!
Great sir! Thank u so much for explaining every detail though still I need to study it hard. I have the similar table in product table but my price column has 3 lookups which (0-2), (3-6), (7 or more) - refering to the quantity being ordered.
Furthermore, i have order table and order detail table. In order table i have only the general info like order date, customer, agent, shipper, total amount. In order detail table has orderdetail ID, order id (foreign key to order table), product, quantity, price (to be generated from product lookup table), and line total.
I am very grateful to watch your videos and excited to learn more from those.
Keep it up! More powers.
I am not sure. THE best Excel question site for back and forth dialog to get Excel solutions is: mrexcel.com/forum
Wow, I've never used LOOKUP before, but now it's time to try ;)
I bow to you, Sir!
You are welcome!!! Glad you like it! No need to bow, just click that Thumbs Up and comment when you are inspired to do so : )
Thanks for the lookup revision
You are welcome, RRR!
Lookup function rocks!
I agree - it has many magic qualities, that fun LOOKUP!
Amazing Mike with an other EXCELlent video. Thanks Man!
You are welcome, Syed! Thank you for the EXCELlent support : )
Great video as always!
Thanks, Teammate!
Really good stuff!
Thanks, Teammate Oz!!!
awesome thank u so much Mr. Mike
You are welcome so much, Ismail!!!!!
Awesome!!!
Glad it was awesome for you, Chris! The next five videos will be a lot of fun with many different solutions and many different formula tricks! Thanks for your support : )
Thanks Mike :) Amazing. This is Great Stuff!!!!
You are welcome, John! Array Formulas are fun : )
Well Done
Glad you like it, and thanks for your great support : )
Very interesting video! Since I have no problem with helper columns, I made one in A11 that's =B11&C1 etc, sorted it and then looked up the price with =VLOOKUP(D22&C22,$A$11:$D$17,4).
Thanks for the hot tip, Teammate! I made a video about your suggestion - its the next in the series : )
Very Smart Mike I am falling behind cause of work Mike I am struggling to keep up the pace :-)
No worries, the videos are here forever! Thanks you very much for your support, Mohamed!!!
ExcelIsFun Yes i khow but i like to be up to speed :-)
I had it in my head that the lookup function had been superseded by the vlookup predominantly, and to a lesser scale by the hlookup. Now I have to reevaluate my thoughts Mike. Feeling confused, but only a bit. Top excel trick, by the master excel teach.
Glad you like the trick, John!! I am not sure what you meant when you wrote "the lookup function had been superseded by the VLOOKUP predominantly, and to a lesser scale by the hlookup". Can you explain more about what you meant? LOOKUP was THE first spreadsheet function in the original 25 functions in Visi Calc. VLOOKUP and HLOOKUP with the ability to do either Approximate Match or Exact Match lookup came later...
Well, I have seen videos and used the vlookup quite often, and it is a brilliant function. I have also, to a lesser degree seen videos on hlookup, and I have also had occasions to use hlookup, but to a far lesser degree. Now, I knew lookup was there, but until an hour ago, I never seen any videos on the function, and I had never looked at it at all. Therefore. I just thought it was brought out in an early package, but was then replaced/superseded by the v and h lookups. Now I need a rethink, as the lookup function can do operations exclusive to the other two? That is a question Mike.
I have used it in about 25 of the 3000 videos I have posted. Here is a great video all about LOOKUP:
ruclips.net/video/N24cBM-CTw4/видео.html
Yes, LOOKUP is a necessary tool because it can do very useful things that VLOOKUP can NOT do.
Amazing Mike.
Glad it is amazing for you! Thank you for your support : )
Tks Mike
Nice
Glad you like it! Thanks for your support : )
Hello Mike, I enjoyed your videos thoroughly. Thank your very much for sharing such valuable material with us.
But there is one thing I don't understand and would like to ask you this question. In this formula =LOOKUP(2,1/(($B$11:$B$17=D22)*($C$11:$C$17
When lookup functions do Approximate Match Lookup and the lookup value is bigger than anything in the lookup column, the function always returns the last item. LOOKUP, VLOOKUP, HLOOKUP, MATCH all have this Approximate Match lookup behavior. When you intentionally give a lookup function a lookup value that is bigger than any value it can find, this is called the "Big Number Lookup to get last item" concept.
Thank you for always clicking that Thumbs Up and leaving a comment to support the channel : )
genius
Glad you like it, Alan! Thank you very much for your support : )
3:00 Sort AZ 6: 25 12:35
I have one question which I want to send you can please give me your mail id or other id where I can upload or send my question excel sheet please helpme