How to Use XLOOKUP in Microsoft Excel - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Nas
so the question is as such i have a coloum with names of sports so for instance -cricket- -soccer- -chess- -ice hockey- -car race- they want me to use a function so that it-ll show first four words of the single word sports and for the -ice hockey- and -car race- Itll show - first three letters of first word and first letter of second word- but they want me to use -if- function for it. The coloum that has the names of the sports (both single word and two words- is labelled -sport- and i have to use -if- function, also they said if they add a new name be it -one word- or -two word- sport, the formula i use should produce the desired result? So for if function how to let the system
know that the sports with single words should show first four letters while the ones with two words should show -first words first three letters and second words first letter-
reply
so the question is as such i have a coloum with names of sports so for instance -cricket- -soccer- -chess- -ice hockey- -car race- they want me to use a function so that it-ll show first four words of the single word sports and for the -ice hockey- and -car race- Itll show - first three letters of first word and first letter of second word- but they want me to use -if- function for it. The coloum that has the names of the sports (both single word and two words- is labelled -sport- and i have to use -if- function, also they said if they add a new name be it -one word- or -two word- sport, the formula i use should produce the desired result? So for if function how to let the system
know that the sports with single words should show first four letters while the ones with two words should show -first words first three letters and second words first letter-
reply
Taylor
Bruh. I was just SHOOK by this video. Like where is my data WHERE. I-m dying to login to work tomorrow. Forwards and back... auto results for my #N/As you gotta be SHITTING ME.
You are my people. Microsoft is lucky to have you because you-re now my new superhero. God speed.
reply
Bruh. I was just SHOOK by this video. Like where is my data WHERE. I-m dying to login to work tomorrow. Forwards and back... auto results for my #N/As you gotta be SHITTING ME.
You are my people. Microsoft is lucky to have you because you-re now my new superhero. God speed.
reply
gary
Thank you for sharing. Easy to understand a fairly complex function.
Now it replaces VLOOKUP and HLOOKUP.
I have found VLOOKUP to be a very essential function for years.
But I am curious, should a beginner learn VLOOKUP before XLOOKUP, or bypass it?
reply
Thank you for sharing. Easy to understand a fairly complex function.
Now it replaces VLOOKUP and HLOOKUP.
I have found VLOOKUP to be a very essential function for years.
But I am curious, should a beginner learn VLOOKUP before XLOOKUP, or bypass it?
reply
Leonardo
Kevin, thanks for your videos, they are helping me a lot in my job. I have 3 different Excel books with similar info (HHRR) but some names could be in one list but not in the other; kindly which function works best to find those differences ?
reply
Kevin, thanks for your videos, they are helping me a lot in my job. I have 3 different Excel books with similar info (HHRR) but some names could be in one list but not in the other; kindly which function works best to find those differences ?
reply
gary
XLOOKUP should save me a lot of time, since I transfer several columns of data.
One challenge, how do we get the fill handle to work on the first formula?
In my Office 365, cannot double click to fill the column. Ideas?
reply
XLOOKUP should save me a lot of time, since I transfer several columns of data.
One challenge, how do we get the fill handle to work on the first formula?
In my Office 365, cannot double click to fill the column. Ideas?
reply
Tangerine
Thanks for an excellent video. Now that I can create drop lists, I need to know how to make the drop list autocomplete when typing in the first letter. Any videos on how to create drop list with an autocomplete option?
reply
Thanks for an excellent video. Now that I can create drop lists, I need to know how to make the drop list autocomplete when typing in the first letter. Any videos on how to create drop list with an autocomplete option?
reply
Tiz
Hello Kevin, I think your videos are exceptional, have perused your Playlist link, what would be usefull is if they could be annotated with when the age of the posting (ie: 6 months) etc.
reply
Hello Kevin, I think your videos are exceptional, have perused your Playlist link, what would be usefull is if they could be annotated with when the age of the posting (ie: 6 months) etc.
reply
Jamie
Great tutorial, simple and clear. Initially watched in full, went away and created my own data set, then worked along side whilst watching the video again and it worked. Many thanks.
reply
Great tutorial, simple and clear. Initially watched in full, went away and created my own data set, then worked along side whilst watching the video again and it worked. Many thanks.
reply
Joe
I was asking myself whether it's possible to use Xlookup in order to find the location of certain values in within a field rage, but I think, I should think of a different method.
reply
I was asking myself whether it's possible to use Xlookup in order to find the location of certain values in within a field rage, but I think, I should think of a different method.
reply
Muhammad
Hi Kevin Stratver
Thanks for all the tutorials
and my question is can we use xlookup function to get the only minimum range and maximum range from an array or table?
reply
Hi Kevin Stratver
Thanks for all the tutorials
and my question is can we use xlookup function to get the only minimum range and maximum range from an array or table?
reply
Add a review, comment
Other channel videos
