Excel VLOOKUP Using Macros VBA in Telugu || MS Excel Tutorial

#excel #excelteluguvideos #excelshorts #exceltips #exceltricks #excelmap #sql #powerbi This Video is Excel VLOOKUP Using Macros VBA in Telugu By Srinivas Reddy Excel Telugu Videos ALT + F11 - VBA EDITOR F8 - To Execute Line by Line F5 - To Execute Entire Program at a time Please Follow us on Instagram:   / srinivasexcelmap   First Macro: ========== Sub Vlookup() Dim x As Integer, erow As Integer, erow1 As Integer, erow = Sheets("Source Data").Range("a" & Rows.Count).End(xlUp).Row erow1 = Sheets("Sheet1").Range("a" & Rows.Count).End(xlUp).Row For x = 1 To erow1 Range("b" & x) = Application.WorksheetFunction.Vlookup(Range("a" & x), _ Sheets("Source Data").Range("a" & x & ":g" & erow), 2, 0) Next x End Sub 2nd Macro: ========= Sub Vlookup() Dim x As Integer, erow As Integer, erow1 As Integer, col As Integer erow = Sheets("Source Data").Range("a" & Rows.Count).End(xlUp).Row erow1 = Sheets("Sheet1").Range("a" & Rows.Count).End(xlUp).Row col = InputBox("Enter the column Number") For x = 1 To erow1 Range("b" & x) = Application.WorksheetFunction.Vlookup(Range("a" & x), _ Sheets("Source Data").Range("a" & x & ":g" & erow), col, 0) Next x End Sub