I'm using the VLOOKUP-function to lookup values in a column based upon a search query. But since it's not a given that a value always exists for my search parameter, sometimes VLOOKUP returns
How do I write an IF-function that tests if VLOOKUP returns
I've read somewhere that
#N/A is just a text string, so I've obviously tried:
But with no luck. So maybe it's not not.
Can you help?