Change the vlookup formula to have a default value if the formula returns an error
I have to wrap my vlookups in an IF statement to check for the result being ISNA. Would be amazingly helpfuly if it could take another input patameter to default on any error condition (e.g. 0 or space are ones that I would use most often).
1
vote
Allan Alexander
shared this idea
1 comment
-
Pip
commented
Use XLOOKUP() instead