Hi,

Can anyone help me how enter this vlookup formula into vba code.

=VLOOKUP("*"&D2&"*",Coding!A:C,3,FALSE)

Regards,
Barieq