Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too




About this tutorial:

Video duration: 11:39
Download Files: Start Excel File:
Entire page with all Excel Files for All Videos: about how to
In this video learn how to how to perform lookup from multiple tables. Learn two methods: 1) VLOOKUP and SWITCH Function or 2) VLOOKUP and INDIRECT Function with Defined Names.
1) (00:01) Introduction
2) (01:30) VLOOKUP and SWITCH Function (New Excel 2016 Office 365 Function)
3) (07:20) VLOOKUP and INDIRECT Function with Defined Names.
4) (11:06) Summary

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

27 thoughts on “Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too

    Uday Kumar

    (December 2, 2019 - 10:48 am)

    No you never stop your videos please your are just special.. And keep do videos please… Am sharing your videos to all my friends and relatives…

    Ankit Verma

    (December 2, 2019 - 10:48 am)

    No one is better than you

    devji patel

    (December 2, 2019 - 10:48 am)

    very very helpful

    steven hong

    (December 2, 2019 - 10:48 am)

    This is very helpful! Thank you!

    China Bono

    (December 2, 2019 - 10:48 am)

    Hi, whenever you have a chance. Please, please make some excel vba tutorials. Thank you en advance

    China Bono

    (December 2, 2019 - 10:48 am)

    Like all your tutorials. Excel-lent

    Joachim Muller

    (December 2, 2019 - 10:48 am)

    Hi, thanks for your great videos.
    In this video you have a list of units and they are overlapping. Quad 1-5 units and then 5-10 units. What happens if you choose 5 units?
    Brgds BHD

    Tim White

    (December 2, 2019 - 10:48 am)

    Thanks for posting the videos. Really appreciate seeing the two example (switch and indirect) to solve the problem.

    David Hansen

    (December 2, 2019 - 10:48 am)

    If you create an Excel table (Ctr T) and mane them properly it indirect will also work…

    David Hansen

    (December 2, 2019 - 10:48 am)

    Have Excel 2016, but not the 365 version so I can't try out the switch function. 🙁

    Владимир Коробка

    (December 2, 2019 - 10:48 am)

    Great video! Unfortunately, don't have switch formula on my work but I have discovered Indirect formula. Still, don't see the logic of it but can see the huge benefits for my work using it. Thank you!

    Do Thanhthao

    (December 2, 2019 - 10:48 am)

    I keep learning your interesting video daily. It's so great and I love them. Thank you for all your works.

    lector0003

    (December 2, 2019 - 10:48 am)

    Love your videos and your voice!! You sound like a cool to hang out with.

    Doug H

    (December 2, 2019 - 10:48 am)

    omg…this is an awesome function….thanks for the video!

    Katse Kala

    (December 2, 2019 - 10:48 am)

    ??? —can't download the associated files – what's up with that? Got : ForbiddenYou don't have permission to access /mgirvin/YouTubeExcelIsFun/EMT1479-1481.xlsx on this server.

    NeoGeoSNK

    (December 2, 2019 - 10:48 am)

    a silly question, do you still have the video for creating dropdown list like this one ? thank you

    chiwila njabulo Sikwila

    (December 2, 2019 - 10:48 am)

    Wow, Great clear explanation of the 2 methods Mike!!

    jawad mansoor

    (December 2, 2019 - 10:48 am)

    @ 7:07 I choose to Choose all the time, but now I am switching to Switch.

    Kartick Chakraborty

    (December 2, 2019 - 10:48 am)

    Sir, I have been learning excel since 2013 by watching your videos on YouTube. I have done some demo projects based on the work experience at my previous companies. Whatever I'm today in excel, just because of you. You are my inspiration, my learning Guru. That's why I'm sharing these 3 projects with you on your Google+ and Twitter Account. Please, Sir, let me know your opinion on these 3 projects. I'm looking forward to your reply.

    Chris Mancinelli

    (December 2, 2019 - 10:48 am)

    Wow, amazing Mike!

    kirti Thorat

    (December 2, 2019 - 10:48 am)

    how to create MIS report? give an example

    Chris Foutch

    (December 2, 2019 - 10:48 am)

    Thanks!

    Haider Ali

    (December 2, 2019 - 10:48 am)

    thanks for sharing…. very informative

    Sajidh Marikkar

    (December 2, 2019 - 10:48 am)

    Hi there, thanks for the great videos. Any plan to do a comprehensive tutorial on financial modelling? It will be really helpful. Thanks!

    Eric Moore

    (December 2, 2019 - 10:48 am)

    Dear Mike, I know this comment isn't supposed to go here, but i have been working on a project that is a mixture of several of your worksheets. I am stuck on a final part of the project that I can not figure out. Is there someplace to upload my project to so so I can show what its not doing correctly?

    Leila Gharani

    (December 2, 2019 - 10:48 am)

    Ohhhh I really like this switch! It really is the swiss army knife of lookup 🙂 Many thanks for the great video.

    pmsocho

    (December 2, 2019 - 10:48 am)

    Great tricks! Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *