When running a Vlookup one of the columns it is returning includes numbers zero to 1000 and also blanks. The returned values for the blanks also show as zero.
Is there are any way to differentiate between the zero abd blanks?
I know I could manually change the blanks to someting like `nul' in the sheet being looked up against but this seems a bit long winded
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!