vlookup macro in excel

[Jaik]

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.
=VLOOKUP(K6,'DataD'!D:G,4,0)





I have something like this but it does not work...
DataD.Range("D:G,4,0") = Vlookup()

does anyone have idea on this?

[rpeare]

This isn't an excel help forum, it's an access forum.

Try here:
https://support.office.com/en-us/art...8-93a18ad188a1

Secondly, if you're using vlookup, make sure the data is sorted by the search column (a to z) or you will likely encounter errors in your search.