Stop Vlookup returning 0

  • 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

  • Re: Stop Vlookup returning 0


    Try


    [COLOR="#0000FF"]=IF(VLOOKUP(....)="","",VLOOKUP(.....))[/COLOR]

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!