Advance Vlookup with VBA Code in Excel in hindi HD

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