Re: Stop Vlookup returning 0
Thanks for this and the quick reply. Works perfectly
Re: Stop Vlookup returning 0
Thanks for this and the quick reply. Works perfectly
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