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.
@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!
@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!
@matthewcolosus
10 ай бұрын
Thank you Chester - I've watched a few videos and yours has been the most helpful.
@Sonia-og1tp
10 ай бұрын
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
@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.
@slnnful8735
Ай бұрын
You can just vlookup them with the same result? No?
@RachelRosenzweig-b7o
17 күн бұрын
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?
@user-vg4qw5ec2k
9 ай бұрын
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?
Пікірлер: 12