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.
I have something like this but it does not work...
DataD.Range("D:G,4,0") = Vlookup()
does anyone have solution for this?