VBA worksheet function vlookup, why doesn't it work?

[OldManExcellor]

I'm trying to use the line below in my VBA code. Any idea why it doesn't work?

article(i) is a string stored in a variable
anchor is a named range

WorksheetFunction.VLookup(article(i), "OFFSET(anchor;0;-8;;13)", "13", "FALSE")

 

[mikerickson]

Try something like

MsgBox WorksheetFunction.Vlookup(article(i), Range("anchor").Offset(0,-8).Resize(,13), 13, False)

The arguments of WorksheetFunctions should be of the data type needed, not strings whose evaluation is of those data types.

When using WorksheetFunctions, one is not writting formulas, one is passing arguments.