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
acadgild.com/b...
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.
VLOOKUP with Exact Match: • VLOOKUP with Exact Mat...
VLOOKUP with Approximate Match: • VLOOKUP with Approxima...
VLOOKUP with Fuzzy Match: • VLOOKUP with Fuzzy Mat...
HLOOKUP in Excel: • HLOOKUP in Excel | How...
LOOKUP Function in Excel: • Lookup in Excel | Look...
Match Function in Excel: • How to Use Match Funct...
VLOOKUP with Match Function: • VLOOKUP with Match Fun...
Please like, Share, comment and subscribe the channel for more videos.
For more updates on courses and tips follow us on:
Facebook: / acadgild
Twitter: / acadgild
LinkedIn: / acadgild

[@willdeit6057]

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

[@7cabeca7]

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

[@watchandlearn5698]

You are great sir

[@kumarmanoj207]

Thanks a lot man

[@rishabh1791]

All the tables should be in same worksheet ??

[@md.mahfuzulalam3350]

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 ?

[@rishanafatima6616]

Can you provide the file?

[@mariacarino5665]

How do you copy the formula?

[@gopalagarwal3795]

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?

[@NZsMa]

So it looks like I can't use a C, c, R, or r to start the name. UGH!

[@kirtinishad96]

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