One more thing, Error trapping.

If the VLOOKUP fails and returns an error [#N/A, #REF, etc.], you may
need something like the ISERROR or ISERR functions as well.

BTW
I wondered if this was possible, but... I wanted a VLOOKUP, so I put
the VLOOKUP and the Table in a Data holding Sheet. Using named
Ranges, the Macro puts the "looked-up" value in a cell and gets the
response from the VLOOKUP cell. An ISERROR function  around the
VLOOKUP flags any error for "gracefulability".