How to do Vlookup with Multiple Tables | How to do Vlookup with 3 Tables | Excel Tutorial

How to do Vlookup with Multiple Tables | How to do Vlookup with 3 Tables | Excel Tutorial
Hello and welcome back to excel tutorials for beginners 2018 powered by Acadgild. In this excel tutorial video; you will see some advanced Vlookup function related to 3 different tables. In the previous videos, you have seen basic Vlookup, Hlookup, Lookup, match and Index functions but this is an advanced Vlookup function where we need to get the data from 3 different tables. Kindly go through the video and learn how to do Vlookup with Multiple tables before that please do watch our previous video for the better continuation by clicking the following links.
Please like, Share, comment and subscribe the channel for more videos.
For more updates on courses and tips follow us on:

[willdeit]

Thank you Been wracking my brain over this for about a week.

[hesperhurt]

You sir, are a legend! You just saved me having to use my brain on a Friday which is, I feel, one of the kindest things one can do for someone. :) Much appreciated :D

[cabeca]

Nice!! Good Idea. I didn't know that I could select an table and name anything in that table. Good Trick!! Hughes from Brazil!!

[rishabh]

All the tables should be in same worksheet ??

[md.mahfuzulalam]

If those tables are not in the same sheet or may be tables from another excel in different drives in the PC what will by the syntax ??? I am requesting for solution

[jansonteoh]

Where is the small dot symbol and big dot symbol ?

[gopalagarwal]

how to contact you, looks like you know excel very well

[NZsMa]

When I try to type in a name, sometimes it works, and sometimes it gives me a pop-up that says "You must enter a valid reference you want to go to, or type a valid name for the selection." I am using vehicle ID's as the section name so I can then lookup who is on which vehicle. If I type R506A it gives me this. Also, in another section, it randomly adds an A in the middle of my R506C to make it R506AC. What am I doing wrong? Why am I getting this error message?

[kirtinishad]

What nonsense.... repeating same thing so many times