Excel Lookup functions, explained: XLOOKUP / LOOKUP / VLOOKUP / HLOOKUP [IGCSE ICT 0417]

Learn all about the Lookup functions, where and how to use them, their advantages / disadvantages and where each one falls short. Why was the XLOOKUP function created and how to use it. In this tutorial i also cover the new SPILL feature. The tutorial is covers all the Lookup functions required for the Cambridge ICT 0417 practical exam paper 3.
0:00 Introduction
0:52 Understanding what a LOOKUP function is used for
2:43 LOOKUP function Vertical lookup
8:32 LOOKUP function Horizontal lookup
10:38 VLOOKUP Function Approximate Match
17:37 HLOOKUP Function Approximate Match
19:37 Where do VLOOKUP and HLOOKUP fall short
23:21 VLOOKUP Exact Match
26:33 HLOOKUP Exact Match
27:34 Using the result of the Hlookup in a calculation
28:19 Using Multiple Workbooks and Spreadsheets
33:37 Why the XLLOOKUP function was created
36:21 XLOOKUP Function vertical lookup
41:20 SPILL feature
43:10 XLOOKUP Function horizontal lookup

Link to the tutorial on References

[cinnapfle]

I’m learning 1 years worth lessons in 5 days this dude is working wonders! Istg if I pass I’ll make an entire speech praising him ❤

[afreeeeeen]

my exam is tmr and you’re saving my life rn THANK YOU SO MUCH

[lilacmoondust]

you explain better than my ict teacher and she's the head of the ict department...

[abdulazizmohammed]

ive watched yahmads ict videos regarding the lookup functions and they were very difficult to understand But the way you demonstrate and explain the examples and how to do them is extremely useful and I was only able to understand this topic thanks to you so thank you so much man I also really really really appreciate the amount of effort you put into your videos so for the third time now thank you so so so much

[khalidyahia]

I cant believe that I found such a thorough explanation of Excel for free.

[potentialofprotonis]

wish me luck!
paper in 2hrs! tqsm for saving my life

[khawajamohammadayaanali]

Thank you so much. You helped me prepare for my exams in the recent days when i had so many things unclear. I am well prepared thats to you🙌

[igcsestudent-fh]

Hello sir! Thank you so much for your videos! I just did my paper 2 the other day, and your voice was flying around my head for the whole 2 hours and 15 mins. Please keep supplying us with these videos, sir, you really are a

[MrGaming-utuy]

Hello I did my paper 2 today and thanks to your help i finished in 1h30m and I knew how to solve everything thank you so much I have paper 3 on Thursday I’m gonna be watching your excel videos too

[llllllll]

You're the best, god bless you NICK!!!

[jennie._]

Thank u so much Nicos! My ICT practical official paper 2 IGCSE exam is on 16th of April...pray for me :)

[SpamAccount-ghev]

Thanks Nicos! I have my paper 3 tomorrow and your videos have been so helpful. If you ever have the chance, I'm doing AS -Level IT next year and it would be so helpful to have A-Level content videos

[ShubhaShrinivas]

very well explained for students. Thank you Mr. Nicos. Continue the good work sir.

[legendmemer]

How do u know when to do approximate match, it is extremely difficult to recognize in papers, can you give an example of a paper question

[m.roui]

For the XLOOKUP's match mode feature, is there a way to display the closest number instead of the bigger or smaller one? Also, what is the wildcard function used for?

[kshamakadam]

Your vids are v helpful.... btw is it ok to use Xlookup function every single time for every situation instead of v lookup, h lookup or lookup? Kindly answer

[someoneyk]

I binge watched excel videos just to get sum and conditional formatting in the exam🤓

[la]

Thank you, but did they ever ask for an approximate match before?

[Saif-ccjq]

Hi there! Thank you so much for your videos, would love it if you did videos for website authoring but in web expressioin 4.

[susu]

Dear sir, How can i get those Excel resource files ?
Thanks