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

Video duration: 11:39
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

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

#### Uday Kumar

(December 2, 2019 - 10:48 am)

#### Ankit Verma

(December 2, 2019 - 10:48 am)

No one is better than you

#### devji patel

(December 2, 2019 - 10:48 am)

#### 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)

#### 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!!

(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!