I created a Vlookup function in Excel Macro VBA. This is a great example for learning VBA, so I'v...
Using Excel VBA Macros to Reference Data from Another Sheet Instead of the VLOOKUP Function
→https://fastclassinfo.com/entry/vba_v...
Creating Excel Functions with VBA: A Series (sumifs, countifs, vlookup, etc.)
→https://fastclassinfo.com/entry/excel...
You can download the Excel file with VBA from the above page.
Table of Contents
0:00 Introduction
0:40 First, let's create a vLOOKUP function
1:45 Benefits of using macros
2:53 Macro programming explanation
3:15 Program 1 | Start program
3:25 Program 2 | Set target sheet
4:00 Program 3 | Get last row
5:17 Program 4 | Set variables
5:33 Program 5 | Get column B from ws1
6:07 Program 6 | Get column A from ws2
6:31 Program 7 | Match column B from ws1 with column A from ws2
6:52 Program 8 | Get columns B and C from ws2
8:08 Program 9 | Output to columns E and F from ws1
9:10 Program 10 | End program, run program
9:35 Detailed explanation of the advantages and disadvantages of macros
10:32 Summary