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 included in the summary count of each column.
1 Reply
- 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.
