vlookup vba

[harvey121]

Hi All,

I'm trying to pass the value of lookCol in the lookup formula here but getting an object defined error here. Can someone please help me with this

lastCol = Cells(1, Columns.Count).End(xlToLeft).Column

lookCol=0-lastCol


Cells(i, curCol).Value = "=IFERROR(VLOOKUP('[OC-App_Weekly(Basesheet).xlsm]Sheet1'!R[0]C[COLOR=#ff0000][[SIZE=2][B]lookCol[/B][/SIZE][/COLOR]],[Sheet1.csv]Sheet1!R2C2:R4C3,2,0),""0"")"

 

[FormR]

Hi, you could try like this.

Cells(i, curCol).FormulaR1C1 = "=IFERROR(VLOOKUP('[OC-App_Weekly(Basesheet).xlsm]Sheet1'!R[0]C[" & lookCol & "],[Sheet1.csv]Sheet1!R2C2:R4C3,2,0),""0"")"