VLOOKUP help

[Cliff Fox]

When using VLOOKUP, how can I get it to return a completely empty cell (with no spaces) when there is no result vs the zero length text cell that ("") produces when used?

[#2]

Hello Cliff

You want something like this:

Give us a proper NULL() worksheet function.

NULL Worksheet Function

Go there, sign in and vote for this issue.

[#3]

Hi Cliff, what is the next step if you get completely empty cell? what is your final objective? Regards, DILIPandey