The value arguments of the is functions are not converted. Syntax of vba vlookup you can use vlookup in macros by following any of the below ways. Using worksheet functions in vba.
