VLOOKUP Between Two Worksheets | How to VLOOKUP From Another Sheet

In this video tutorial I demonstrate how to VLOOKUP between two worksheets. I explain three ways this can be achieved.

Table of Contents:

00:00 - VLOOKUP between two worksheets
03:20 - VLOOKUP between two worksheets using named ranges
06:02 - VLOOKUP between two worksheets using Excel tables (dynamic range)
------------------------

[batmanforever]

God bless you. Finally someone with straight forward tips.

[kristenvanness]

I have struggled with Vlookup and this is the first time i've been able to get it to work. THANK

[silviopoggi]

I'm coming to this video a bit late. However, I have used your tutorials for quite some time as my Excel questions come up and I just want you to know that your presentations are absolutely the best. Clear, concise, and so valuable. I would give you multiple "thumbs ups" if possible.

I'm in my 70's and trying to help my grandson set up an accounting system for his attempt at starting a "very" small business and your efforts are greatly appreciated!

[hasanghassan]

I like you Man, your explanation is amazing

[Graciel]

This is my best VLOOK UP Tutorial. Thank you Chester!!!!

[heatherspa]

Thank you for posting this. I was becoming frustrated on a multiple tab, file vlookup and your tutorial helped massively!

[jimhegarty]

Thank you. Simple and easy to understand.

[kgsejjt]

simple, thank you, great example. I keep forgetting how to do this so I'll save your video for next time

[IvanCortinas_ES]

Excellent explanation. Very rigorous and pedagogical. Thank you Chester.

[DivaStyle]

This was perfectly demonstrated and explained. Thank you!

[nellyadrian]

This is so straight forward....I have to watch all your videos from now onwords, you make this look so easy and its indeed easy.

[stephanieperry]

Your tutorial is the only one that helped me! Thank you very much!

[ZapharAzzad]

You're awesome brother, appreciated and thank you for the all efforts you made for the purposing understanding people.

[msbutterfly]

Wow I really like the last feature you did, wonder why I have yet to see a video on it. Thank you, appreciate you taking the time to do this video. Helpful. Cheers

[selvam_videos]

Thank you, Chester. Very useful and easily explained.

[aac]

Thanks Chester for a wonderfully explained and very useful Information 👍

[usmaniqbal]

Perfect, Sr please share excel workbook for practice

[KathleenPemblington]

I recently enrolled on an advanced excel course and this (Chester Tugwell) is by far better than the course I'm working on. I'm not new to excel with working in finance but I am new to Vlookups.

I've just worked through the VL between two sheets. I've copied the dated i'e Sales, Product, Region and although I know my formulas match Chester's, only some of them are correct. Some are returning N/A.

Please help as I'm totally stuck.

Thank you.

Kathleen.

[nellyadrian]

Do we have another fomuter that works similar with Vlookup?

[jokerrhe]

When I select the columns it puts them by [[name bracket]:[name bracket]]], then gives me error in the end. Driving me nuts.