📈Lookup functions | Index & Match | Automation📉
The video is all about Lookup functions (VlookUp, HlookUp, XlookUp), and Index & Match, their advantages and drawbacks, several features, and how to use these functions in automation.
Here, at Excel Carols, the aim is help viewers with all queries related to Ms Excel. Please watch the video till the end and let us know if you benefit from it, in the comments section below.
VlookUp - 00:27
Entering VlookUp formula - 00:54
Exact Match & Approximate Match - 01:59
VlookUp when data is in different sheet of the same workbook - 02:42
VlookUp mandatory condition - 03:21
HlookUp - 03:31
HlookUp when data is in different workbook - 04:24
HlookUp mandatory condition - 05:04
Index & Match - 05:18
Entering Index & Match formula - 05:49
Advantage of Index & Match over VlookUp and HlookUp - 07:23
XlookUp - 07:42
Entering XlookUp formula - 08:07
Pro tip - 08:39
Modifying XlookUp - 09:00
Automate - 11:24
Please like and share the video if you find it useful. Please mention your feedback in the comments section below. Don't forget to subscribe to the channel and press the bell icon in order to get all the notifications.
Follow instagram handle - https://instagram.com/excelcarols?utm...
#ExcelCarols #MsExcel #VlookUp #HlookUp #Index&Match #AdavncedExcel