Can the vlookup function be able to use a lookup_value that is BLANK or NULL. I have a table that returns a BLANK cell occasionally in the column used for the "lookup_value". I would like the vlookup function to still work by looking up a NULL field. Something like isnull () or isblank(). Thanks in advance.