Hi,

I'm trying to use Vlookup in a UDF and would like to used a named range I
already have specified as the lookup range. Excel doesn't like the 'raw'
reference.

e.g.

Function Include(Client As Variant, Task As Variant)

If WorksheetFunction.VLookup(Client, ClientTable, 2, False) = "Yes" Then
Include = "Yes"
..... more to come...

End Function

Any suggestiosn please?