Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?

See how to do a VLOOKUP to a different Sheet using:
1. Sheet References
2. Defined Names
3. Table Formula Nomenclature (Structured References)

[bokangmotopi]

Don't care if no one gets to see this but this video just SAVED MY LIFE (a lil dramatic but yeah)
I've been at this for at least 3 hours and I finally figured it out with your help. Thank you so

[sonrisa]

This was the best VLOOKUP video for explaining the formula and end goal. Thanks!!

[davechiu]

Thank You so much. I can't tell you how many videos and links I tried before finding this one. Really great Well done. Subscribing!!!

[tertybrown]

Had to use this formula for work. Went to multiple guides and vids but yours got me to understand it under 1 minute. Thank you soo much.

[codysnyder]

The BEST VLOOKUP video I've found so far. Thank you!!!

[Jlbjessyb]

Best V Lookup video - looked at about 6 before this one and had failed attempts. Got it in 2 seconds with yours! Thank you so much :)

[natashasamuel]

Great class.
Keep up the good work.

Thank You,
Natasha Samuel

[froufou]

Well am glad I found you. I am taking on online excel class and couldn't understand the tutor vlookup explanations on merging data so kept on getting it wrong with the test. All good with you Sir :), thanks

[allengreene]

oh. my. dear. sweet. god.  I love you.  I can, not, tell you how long I have searched for exactly this.  As someone who processes 59 columns over 8000 rows running vlookups on an array with 21 columns over 10, 000 rows on a monthly basis with around 20 vlookups in macros and often shifting columns  - this is beyond words..  You are a true genius, I've subscribed and I will be back for more!  THANK YOU THANK YOU THANK

[SirSoulhunter]

I learn something new, every time I watch one of your videos, love the table nomenclature angle, going to search for those next, looks like there is power there to be tapped.

Thank you Mike

[santoshpandi]

Thanks a lot, Sir. It helped me to learn the small concept of Vlookup which I was getting stuck from the past 2 weeks as I was depending on my senior, as he was making me roam for it. At last, learned with the help of u:):) Thanks a lot.

[TheCribNetwork]

Thank you very much, this was very helpful and very direct

[miyucafe]

Best video ever !!! You are an amazing teacher! Thank you

[maniacallaugh]

Defining the table name completely solved the VLOOKUP issue I was having - and it's something I wouldn't have thought of. Thanks!

[jerrylouis]

Nothing more to say! Everything already said and praised! Gr8 work!

[contextures]

Nice demo of the different ways to refer to the lookup table!

[atinanajahan]

This was 7 year ago but I believe it will still be benefited people for ten more years at least. Thank you this vid really save me for my school project

[ovaispathan]

Awesome have wasted hours to find out why my multiple worksheet Vlookup is not working ..i was missing pressing F4 and actually i did not have any idea about those $$ we need to append with Table_Array range.... thanks a lot Sir ... appreciate a ton.

[LaFamiliaLopezWi]

Excellent!!! Solved my issue! Thanks a lot!!! Great tips in between.

[tuannuramaninat.m.nawawi]

thanks a lot, yr method is very understandable and easy to follow . bravo!