• Vehicles • Fashion • Recipes • Blogs • Hunt • Travels • Sport • Fun • Handmade • IT • Education
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
XLOOKUP in Excel Kevin Stratvert

XLOOKUP in Excel Kevin Stratvert

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
XLOOKUP in Excel Kevin Stratvert beginner's tutorial, learn how to use the XLOOKUP function in Microsoft Excel. With Excel XLOOKUP formula, you can look up values on the same worksheet or between multiple worksheets. For example, let's say I have a cookie name, chocolate chip, my favorite, and I want to know the price. I have another table with the prices. I can look up the cookie name and get the price back. We'll look at how this function works in the simplest form and then we'll look at more advanced capabilities. XLOOKUP is currently available to Microsoft 365 subscribes. If you don't have Microsoft 365, you can use VLOOKUP or HLOOKUP. - Additional resources - Sample spreadsheet to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whM4IxMRV87IJqXHing?e=9xO0Z7 - How to use VLOOKUP in Excel - Complete Tutorial: https://youtu.be/DZEPA9UhLBw
Date: 2022-03-15

Comments and reviews: 10


Kevin is such an amazing teacher. He intuitively expects the exact question that pops in my mind as he instructs, and always answers simply, thoroughly and pleasantly.
One request - with all the 60+ fantastic videos available, I wish they could be listed in order of basic to difficult, so I know what to watch next. I know it's subjective for some, looking for a specific tasks.

reply

Kevin you have such interesting and informative videos......I have a question...am a teacher and am tired of marking exams or assignments for my students....whether in soft or hard copy....what approach can I use to ease my work and safe me time to do other things.....preferably using my computer?....my name is Philip......Thank you
reply

You know what i always try to watch videos even i know that featur but i willalways be amazed by hidden or complete futures until u have covered. Today its returnin multiple lists and without helper column combining search array and grideview.
reply

I am from Saudi Arabia and my English is not good, and despite that, I used a translator to put a comment for you. I wish you would put an Arabic translation because your content is very easy and easy to apply, so this is my wish
reply

Hello, this is my xloopup formula I have in my spread sheet: =XLOOKUP(1,B10:B400,A10:A400,,,-1). It works, but what if i want the look up value to be Greater than or Equal to -1-. Is it possible to formulate that?
reply

Kevin, I have enjoyed your videos and how simple but effective are your explanations and sequence you use to explain concepts. Kudos. As an educator I take my hat to you. Outstanding and keep up this great work.
reply

Hi Kevin, Can you pls help with the below query. When an youtube video is uploaded its fine. After some time, only audio is heard and video is blurred. What could be the issue? Please assist. Thank you
reply

Thank you Kevin for the nested Xlookup example! Even though we may alternatively use INDEX and MATCH functions to get the same result, nested Xlookup is much easier to use!
reply

I'm grateful for your content, Kev! Learning this in school and your explanation is way better! Thank you for also using cookies as an example -- I'm able to understand 100%
reply

Thank you Kevin! I'm learning so much about -Lookup- functions. People handle so many data and this is a great help for those who work a lot with Excel sheet.
reply
Add a review, comment






Other channel videos