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)
------------------------

[SoydanMulayim]

Finally someone explaining this thing clearly ❤

[seleneclytie]

This is so helpful. Thank you so much.

[luchecuyos]

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

[IvanCortinas_ES]

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

[shiahas]

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!

[phillygirl]

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!

[Sunny-hgl]

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

[matthewcolosus]

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

[usmaniqbal]

Perfect, Sr please share excel workbook for practice

[RachelRosenzweig-bo]

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?

[PaulWork-txfg]

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.

[slnnful]

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

[PaigeLeslie-tq]

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?