THis line of code works:

[VBA]
Range("E2:E" & finalRow).FormulaR1C1 = "=VLOOKUP(RC[-1],'[BusinessReportingReference.xls]Whses'!C1:C8,2,FALSE)"
[/VBA]

THis one doesn't:

[VBA]
Range("E2:E" & finalRow).value = VLOOKUP(RC[-1],'[BusinessReportingReference.xls]Whses'!C1:C8,2,FALSE)
[/VBA]