I'm using the
VLOOKUP function and I have this function
It works but what do I need to add so the cell will display nothing if B9 is nothing? At the moment if B9 is nothing it displays "#N/A". Thank you.
migrated from stackoverflow.com Aug 1 '12 at 2:59
This question came from our site for professional and enthusiast programmers.
You can surround the whole thing with an
with any suitable changes to the
That way it gives you
For your question as asked
Going a step further in case your value in B9 does not exist in your lookup range
Useful reference. Patrick Matthews (MVP Excel), Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work
[The other post wasn't flagged to me at the time when I posted, that said I do recommend the additional ISNA test that I added]