Hi Mark

Try this:

First.Formula = "=VLOOKUP(" & FirstB.Address(False,False) & ",
'download.csv'!$A$2:$J$5000,10,FALSE)"

Hope this helps!

Richard



On 19 Feb, 09:20, "MarkHear1" wrote:
I am using the below formula and it works a treat. However I want the
'FirstB.Address' to be input as a relative reference rather than the
default absolute reference. Could anybody offer any help as to how I
could do this? Many Thanks.

First.Formula = "=VLOOKUP(" & FirstB.address & ", 'download.csv'!$A
$2:$J$5000,10,FALSE)"

Regards,
Mark