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

[@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!

[@cizmelikedi7777]

Finally someone explaining this thing clearly ❤

[@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!

[@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.

[@LillianAlari-hr6mc]

Thank you so much!! It was so easy to follow your instructions and look forward to watching more of your videos😌

[@Sunny-h3g2l]

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

[@txthazelnut]

Thank you so much

[@Rutendo37]

I've watched a few videos and still couldn't get things working. Your explanation was clear, thanks.

[@luchecuyos2254]

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

[@JohnYoga]

Nicely done Chester. Thank you.

[@seleneclytie]

This is so helpful. Thank you so much.

[@usmaniqbal1836]

Perfect, Sr please share excel workbook for practice

[@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?

[@MohamedABDELBARY-SC]

Thank you so much.

[@kensleylewis-n2b]

well done

[@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.

[@lois101oyes]

thank you sir

[@MohamedABDELBARY-SC]

ty so match

[@slnnful8735]

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

[@RAJOHN-ke7mc]

No v lookup only looks for a value to the left (verically on the x axis. X lookup looks up values anywhere on the sheet ( vertically or horizontally on the x or y axis) It's much more powerful

[@PaigeLeslie-t6q]

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?