VLOOKUP/IFERROR - lookup values

[Forestq]

Hi,

I have vlookup

ActiveCell.Formula = "=IFERROR(VLOOKUP(R2,'" & sfullpath & "'!" & Rng & ",3,0),""Other"")"

and it's working.
But I don't want to start from R2. Possition is choosen before and it's called rows_x_begin:

for example: rows_x_begin = 26
so it should be R26

how to add rows_x_begin into function.

I tried:

ActiveCell.Formula = "=IFERROR(VLOOKUP(R 'rows_x_begin','" & sfullpath & "'!" & Rng & ",3,0),""Other"")"

but failed

 

[Peter_SSs]

Try
"=IFERROR(VLOOKUP(R" & rows_x_begin & ",'" & sfullpath & "'!" & Rng & ",3,0),""Other"")"

 

[Forestq]

thanks Peter_SSs! you rock!

 

[Peter_SSs]

thanks Peter_SSs! you rock!

You are welcome. Glad it helped.