vlookup formula in vba marco

jaik22 · Sep 23, 2016

I want to make a macro based on vlookup formula from excel sheet.
this formula is looking at k columns and go DataD sheet to get a value.

Rich (BB code):

=VLOOKUP(K6,'DataD'!D:G,4,0)

I have something like this but it does not work...

Rich (BB code):

DataD.Range("D:G,4,0") = Vlookup()

does anyone have solution for this?

Jeffrey Mahoney · Sep 23, 2016

How about this Jaik?

Code:

Sub Lookup()  Dim v As Variant
  v = Application.VLookup(Range("K6"), Sheets("DataD").Range("D:G"), 4, False)
  MsgBox v
  
End Sub