Question: how to have vlookup return blank?
Answer: (1.) Specify the lookup value and output range as you need;
(2.) Choose the returned result as you need, you can select Replace 0 or #N/A value with empty option or Replace 0 or #N/A value with a specified option;
(3.)