Vlookups

%3CLINGO-SUB%20id%3D%22lingo-sub-660425%22%20slang%3D%22en-US%22%3EVlookups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660425%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20can%20someone%20provide%20me%20with%20the%20vlookp%20command%20to%20return%20blanks%20as%20blanks%20when%20looking%20a%20t%20a%20range%20of%20data.%26nbsp%3B%20I%20am%20getting%200's%20returned%20which%20when%20I%20run%20a%20pivot%20table%20they%20are%20being%20included%20in%20the%20summary%20count%20of%20each%20column.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-660425%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-661056%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookups%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661056%22%20slang%3D%22en-US%22%3EFormulas%20never%20return%20blanks%20(no%20text%20or%20number)%2C%20but%20may%20return%20empty%20texts%20(%E2%80%9C%E2%80%9D).%20In%20Excel%2C%20blanks%20are%20%3D%20to%20%E2%80%9C%E2%80%9D%2C%20and%20%E2%80%9C%E2%80%9D%20is%20counted%20as%20blank%2C%20but%20%E2%80%9C%E2%80%9D%20is%20not%20blank%20because%20it%20is%20text.%3C%2FLINGO-BODY%3E
JudeKelly
Occasional Visitor

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.