Advance Vlookup with VBA Code in Excel in hindi

Vlookup VBA Code
Dim a
Dim b
Dim c
Dim d
Dim e

a = Application.VLookup(Range("E3"), Sheet1.Range("B3:G18"), 2, 0)
Sheets("View").Range("E5:I5").Value = a

b = Application.VLookup(Range("E3"), Sheet1.Range("B3:G18"), 3, 0)
Sheets("View").Range("G6:I6").Value = b

c = Application.VLookup(Range("E3"), Sheet1.Range("B3:G18"), 4, 0)
Sheets("View").Range("G7:I7").Value = c

d = Application.VLookup(Range("E3"), Sheet1.Range("B3:G18"), 5, 0)
Sheets("View").Range("E8:I8").Value = d

e = Application.VLookup(Range("E3"), Sheet1.Range("B3:G18"), 6, 0)
Sheets("View").Range("E9:I9").Value = e

Видео Advance Vlookup with VBA Code in Excel in hindi канала Daood Computer Centre