A Practical Introduction to Using FIND Function in Excel VBA || Perform any kind of Lookups
Want to become an expert at looking up data? The Find Function is a highly versatile way of searching for related data in a worksheet. The most common use case would be to a Vlookup style operation. However, there is so much more that you can do with this function. And we will explore all of it in this video.
Practical Example:
Read through a monthly invoice statement, dynamically identify the REAL data range and create a report using various lookups.
Download Code from my blogsite:
https://skillsandautomation.com/how-t...
Download Macro File from Github:
https://github.com/skillsandautomatio...
Instructions on how to Download the Macro File from Github:
https://skillsandautomation.com/how-t...
00:00 Intro
00:50 Basic Section - Theory
02:00 Basic Section - Perform Single Lookup
04:37 Basic Section - Perform Lookup in a Loop
05:34 Advanced Section - Dynamically Identify a Range
09:43 Advanced Section - Locate Last Row with Data
11:47 Advanced Section - Create a Generic FIND Function
15:24 Advanced Section - Search for Text within Text
17:33 Advanced Section - Filter Data
21:22 Advanced Section - Caution While Using FIND
