How to Use XLOOKUP Across Two Worksheets | XLOOKUP Examples Across Two Sheets

In this video I demonstrate how to use XLOOKUP to lookup across two worksheets. I explain two methods you can use to achieve this.
Table of Contents:
00:00 - XLOOKUP between two worksheets
03:34 - XLOOKUP between two worksheets using Excel tables (dynamic range)
------------------------

[@luchecuyos2254]

Thanks heaps, Chester. I never understood this until I saw this video of yours.

[@phillygirl5623]

I love all of your videos 😊 what you do is amazing . You truly have a gift to train and educate. There are thousands of Excel tutorial videos online; however, the other videos mean nothing if the facilitator lacks the "how to" which goes hand and hand with the online video tutorial. THANK YOU 🙏 KINDLY!

[@shiahas4697]

Thank you. I wanted to learn XLOOKUP and watched quite a lot of videos before I found yours and your explanation was the easiest to understand and implement. This video is a really huge help! Thank you very much!

[@IvanCortinas_ES]

Again another great tutorial. Thank you for explaining these search functions in such detail.

[@matthewcolosus]

Thank you Chester - I've watched a few videos and yours has been the most helpful.

[@Sonia-og1tp]

This was so helpful! Thank you for explaining this step by step snd so clearly! I finally understand vlookup!

[@usmaniqbal1836]

Perfect, Sr please share excel workbook for practice

[@lois101oyes]

thank you sir

[@RachelRosenzweig-b7o]

I followed this both ways, but the formula is not giving me the results. It is just showing the formula still. i even tried doing Text to columns but that is still not working. What am i doing wrong?

[@slnnful8735]

You can just vlookup them with the same result? No?

[@PaulWork-tx8fg]

Hi Chester - I've been searching and taking a little from a lot of location to build out my Project tracking Xls - But I'm now stuck with a simple issue but I cant find an answer for - Guessing its how I'm asking my question - I have 2 tables on 2 sheets in 1 file - Both tables are dynamic and changing every week - 1 is my master list of all staff across all my projects 50+ names with serial nbr to make this my primary key. Then the 2 table is in the weekly time sheets with 300+ lines with duplications where I add this up in a different location for their sum. I'm using =XLOOKUP(A2,'RPV Data'!B:B,'RPV Data'!A:A, "...") that finds a match only against the same name in the Staff table. What I als want to show is any additional names in the timesheet table as this is a copy and paste from another location - is there a way to add new names in my xlookup col at the bottom in the first blank line? Then I can manual update that line with their details in Col A&B to make them found with my current xlookup.

[@user-vg4qw5ec2k]

Hello, Can you please help me? I'm trying to import specific data from 1 different Google Document to another. I want it to use 3 qualifiers (business name, location and date) from one document to pull the sales for the business into the second document.
This is the formula I am using -
=XLOOKUP(A10&B10&Y4,INDEX(IMPORTRANGE("1df9lpHp-7e4xNeVVkO1kSWgCESQeoBdBOns_hU8K9cg"),("A2:A100&B2:B100&C2:C100"),"D2:D100"))
It keeps giving me this error -
Wrong number of arguments to XLOOKUP. Expected between 3 and 6 arguments, but got 2 arguments.
What am I doing wrong?