Hi.
I am using two sheets and i need to use the Vlookup function but through VBA.
It's complicated why i need to do it through VBA but basically i need to use the cell that i'm looking up to offset from the active cell.
Here is an example of what i came up with but it doesn't work :
ActiveCell.Offset(0, 1).Formula = "=VLOOKUP(" & ActiveCell.Offset(0, -29).Value & ",BrandList!A2:D71,4))"
It gets even more complicated because i need to combine the value of 3 cells that will have the vlookup but i'll figure that out later
I was, however, wondering if maybe i don't need to use the vlookup function when working with macros and maybe there is some other way to lookup values in macros?