The XLOOKUP function now makes this task even easier - kzitem.info/news/bejne/1IqgmX-km3l3m4I
@revanvonheaven8270
Жыл бұрын
Hey mate can I reach you about the counting cards and lottery numbers I hope I can help you try doing this get a notebook 📔 and record all the numbers 4 times a week twice for all 12 months in a row could you be able to help me calculate 5 probable combos in the duration period of time of the next 12 months next year yes or no?.
@willisjwhhbjrjrb
4 жыл бұрын
After watching countless of videos and searching all over and reading articles, the logic only made sense with your wording. Thank you.
@Computergaga
4 жыл бұрын
That is nice to hear. Thank you for your comment.
@anelimrimo
5 жыл бұрын
I'm taking an excel class and I didn't understand my teacher, but I understand you. Thanks so much.
@Computergaga
5 жыл бұрын
Great to hear. Thank you Milena.
@iheartbunnies1121
4 жыл бұрын
I haven't commented on any videos for so long but just wanna say tysm sir u saved me a lot of trouble and ur a real g
@Computergaga
4 жыл бұрын
Thank you very much.
@saifalislam5987
4 жыл бұрын
Have been watching some other videos on this topic , but this video explained it so well , Thanks!
@Computergaga
4 жыл бұрын
You're very welcome! Thanks Saif.
@SivadasKRamdas
6 жыл бұрын
Thanks Buddy, this video helped me a lot to solve one excel problem i was facing.
@Computergaga
6 жыл бұрын
Great to hear. Thanks Sivadas.
@etpollylifts
5 жыл бұрын
God bless you. Thank you for this tutorial you saved me
@Computergaga
5 жыл бұрын
Excellent. Happy to help Ethan.
@keithtomalin3172
5 жыл бұрын
Great Video... Sooo much better than Vlookup. Well done and thank you.
@Computergaga
5 жыл бұрын
You're welcome Keith.
@4nnbnn
5 жыл бұрын
Thank you so much for your help!Really detailed and well explained!
@Computergaga
5 жыл бұрын
Thank you.
@gabrielcastillo4126
3 жыл бұрын
Thank you so much for your videos!
@Computergaga
3 жыл бұрын
You're welcome, Gabriel.
@kvlpnd
6 жыл бұрын
2:50, " I don't wanna hurt its feelings " 😂😂
@Computergaga
6 жыл бұрын
:)
@arifurrahman4407
5 жыл бұрын
Sir, Thank you so much for your most useful tutorial.
@Computergaga
5 жыл бұрын
My pleasure. Thank you Arifur.
@ihormaza1
6 жыл бұрын
Thank you for your detailed and clear explanation. It was very helpful!
@Computergaga
6 жыл бұрын
You're welcome, thank you.
@KaldaneAnswers
4 жыл бұрын
Nice Video. I always like the way you explain things
@Computergaga
4 жыл бұрын
I appreciate that, thank you.
@lucmorineau6741
4 жыл бұрын
Excellent video and explanation, thank you so much! I made some update to your proposal to use tables, also working well :)
@Computergaga
4 жыл бұрын
Brilliant. Thank you Luc.
@sandeshmainali7045
4 жыл бұрын
Thank You for the video :)
@Computergaga
4 жыл бұрын
My pleasure, Sandesh.
@angelkz7427
5 жыл бұрын
Thank you! Just what I've been looking for!
@Computergaga
5 жыл бұрын
You're very welcome Angel.
@mightyhunter7849
7 жыл бұрын
Thumb Up sir . my question is : how did you convert match formula in row number? on the time 9:55 plz reply
@Computergaga
7 жыл бұрын
Thanks Hafiz. After highlighting the MATCH part of the formula, I pressed F9 on the keyboard. This manually calculates that part of the formula. Really useful when testing and fixing formulas.
@enochnanduru
5 жыл бұрын
@@Computergaga Seriously, you are Master Jedi, all excel based honor and glory be unto you Sir.
@cipher2
5 жыл бұрын
Excellent excel tutelage channel!!!
@Computergaga
5 жыл бұрын
Thank you very much.
@youlilgremlinkun
4 жыл бұрын
Thank you for the video! One question: Is there a benefit to a two-way lookup function? When you brought it up, I wasn't clear on why it was beneficial to have a Match for the column. I was thinking in my head "Why wouldn't we do what we did earlier and select the specific column as the table array?" I feel like I'm missing out on how it can be useful in some scenarios, so if anyone has an answer, I'd appreciate it! Thanks again for the video, much appreciated for the help!
@808BLAddict
3 жыл бұрын
KnockEmmm I had the same question.. it seemed less complicated to just do a one way look up and it looks as if it would give you the same results... if anyone can explain the benefits of a 2 way I would appreciate it too!
@mohamedmami2480
7 жыл бұрын
Great! Thanks a lot Alan..
@Computergaga
7 жыл бұрын
Your welcome Mohamed.
@j.d.r2049
5 жыл бұрын
Very useful
@Computergaga
5 жыл бұрын
Thank you Vishwa.
@posfr292
5 жыл бұрын
For years I resisted Excel Tables instead of old-school ranges and INDEX-MATCH instead of VLOOKUP. Now, having used Power Query, I'm totally converted - born again. With Tables, and using "structured references", the MATCH and INDEX functions write themselves and become self documenting. If you convert your range to a Table and name the table COURSES, the first of your formulas becomes something like =INDEX(COURSES[Company], MATCH(4202, COURSES[Course ID], 0))
@Computergaga
5 жыл бұрын
Yes tables are fantastic. There are still some things for Microsoft to iron out to make them perfect, but a big improvement in many ways especially dynamism, structured references and then the use of the Power Tools.
@miguelgaitan1630
Жыл бұрын
Hello, I'm very interested in taking a course in Xlookup, indexmatch, formulas
@Computergaga
Жыл бұрын
Sure. There are course links in the video description. There is also my 'Advanced Excel Formulas' book with over 500 formula examples - amzn.to/3Rg87Go
@alexrosen8762
6 жыл бұрын
Just awesome! Thanks a lot :-)
@Computergaga
6 жыл бұрын
You're welcome. Thanks Alex.
@mrbuthelezi7121
4 жыл бұрын
i have been struggling with this function for a while, the n i watched this video and attempted the problem i had at work once. never been this happy in a long time Thanks man ☺•o☺♂♂o♂♂
@Computergaga
4 жыл бұрын
Great to hear. Thank you, Vincent.
@marktimson1485
3 жыл бұрын
Thanks for a very easy to understand video. A question for you if you can help. How do you use index match to ignore a blank cell? For example, a data table of football matches to be played still, no scores in the scores column but in the fixture grid the scores all show as 0-0, when the scores are entered in the data table it shows in the fixture grid correctly. So how can get the fixture grid to show nothing(blank) instead of 0. This is the formula i have showing in the home team on the fixtue grid...{=INDEX(Fixtures!$G$4:$G$555,MATCH(Sheet1!$C6&Sheet1!$D$4,Fixtures!$F$4:$F$555&Fixtures!$I$4:$I$555,0))}. But like I said it shows 0 instead of nothing if no score is entered.
@artlogo1881
5 жыл бұрын
Is there a search button that can produce 3 results, A button you press ?
@RB-os7qw
2 жыл бұрын
Do you do online courses?
@Computergaga
2 жыл бұрын
I certainly do. You can find my courses and books at computergaga.com
@granand
6 жыл бұрын
Sir How should I list all the companies offering the course ID, the list should be in same cell appended by "," comma.
@Computergaga
6 жыл бұрын
I would use VBA. The unknown quantity of companies make using a formula and concatenating them awkward.
@gerardvaneggermond9967
4 жыл бұрын
Hello, maybe you can help me, I have an Excel sheet, in which I have 9 cells, I have this in Sheet 1, in sheets 2 and 3 I have data where I want to retrieve things and this must meet certain conditions, it is a lot, how do I do that?
@Computergaga
4 жыл бұрын
Merge Queries is one of the easiest ways - kzitem.info/news/bejne/0nmuvIGGbqWip44
@chinmayeesingh9040
7 жыл бұрын
Till today i cd not understand the actual funda of match n index actually
@quocvietdang8118
5 жыл бұрын
Hay
@ashutoshdwivedi9600
4 жыл бұрын
Super knowledge sir Still I'm waiting your reply in mail
@Computergaga
4 жыл бұрын
Thank you Ashutosh.
@waynebrown8366
6 жыл бұрын
Couldn't you have used a simple INDEX/MATCH to find Number of Delegates instead of a 2-way I/M as well?
@Computergaga
6 жыл бұрын
Yes absolutely. Just wanted to demonstrate a 2 way lookup so that we did not need to specify the exact column.
@jackychawla5422
7 жыл бұрын
Sir please add some complexity
@Computergaga
7 жыл бұрын
Jacky, your a beast. I will try.
@jackychawla5422
7 жыл бұрын
Computergaga sir please cover dis topics once for all
@novellez
5 жыл бұрын
vlookup is much easier and quicker
@Computergaga
5 жыл бұрын
True. I got a lot of love for VLOOKUP. The INDEX & MATCH combo offers a more flexible alternative that is often not required, but awesome when needed.
@notawix8542
3 жыл бұрын
now there is X loockup
@Computergaga
3 жыл бұрын
There is indeed - kzitem.info/news/bejne/1IqgmX-km3l3m4I
@mikejaoude5496
4 жыл бұрын
Anyone ever have an issue where when you choose your array you don't use entire columns (so you do for example A2:C11) and the data you get out is always a row off? For example if I do this: =INDEX(A2:C11,MATCH(G3,A:A,0),MATCH(H2,A2:C2,0)) It always gives me a row lower than what the value should be for cell G3. But if i do this, it is correct: =INDEX(A:C,MATCH(G3,A:A,0),MATCH(H2,A2:C2,0)) Do you always have to run with full rows/columns?
@Computergaga
4 жыл бұрын
Hey Mike, you don't have to use entire columns. But they need to start from the same place. The first MATCH function - MATCH(G3,A:A,0) will count from row 1 because it is given A:A. But INDEX is returning from a range beginning A2. The MATCH function doesn't return the row number. It returns the index number from where it found the value. Hope this helps explain.
@mikejaoude5496
4 жыл бұрын
@@Computergaga thanks for the quick reply. That was actually super helpful. So I changed the row Match from A:A to A2:A:11like you said and it worked! You're the best thanks!!
Пікірлер: 80