Excel Lookup Function Basic to Advanced
In this video, I will show you 7 examples that how to use the Microsoft Excel #lookup function.
You may choose the timestamps to jump on the topic
00:00:39-How work LOOKUP Function
00:03:41-Lookup Data Bottom to Top (Approximate Match)
00:05:19-Lookup Data Bottom to Top (Exact Match)
00:07:59-Lookup Value from the Last Non-Blank-Cell
00:10:42-Grouping of Numbers (Single Table)
00:13:50-Grouping of Numbers (Multiple Table)
00:16:20-Lookup Multiple Cells in a Range
Subscribe to YouTube & Follow on Facebook Page👇
https://www.YouTube.com/exceluniverse
https://www.facebook.com/exceluniverse.in
Checkout Some Other Excel Tutorials Videos:
VLOOKUP Basic to Advanced👇
https://youtu.be/w-lJ-NvdMlM
Lookup Function👇
https://youtu.be/8nCotivDIMU
All about SWITCH Function👇
https://youtu.be/a_pK-tc2f4Y
How to use Index Match in Excel👇
https://youtu.be/ORn3h4KoNp4
INDEX+MATCH Advance Tricks👇
https://youtu.be/dSmUGx0_2eA
Download the practice file here👇
https://mega.nz/file/lvxy0QYY#xFOUYepvvv1g-wdQlnxor0kwfF71AeLaC0WDrAUB7gg
#excel #lookup #exceltutorial #switch