Forum Discussion
Vlookups
Hi Please can someone provide me with the vlookp command to return blanks as blanks when looking a t a range of data. I am getting 0's returned which when I run a pivot table they are being incl...
Formulas never return blanks (no text or number), but may return empty texts (“”). In Excel, blanks are = to “”, and “” is counted as blank, but “” is not blank because it is text.