Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup Null values
I am looking up values in a Pivot Table. If the value is null, the formula
is displaying zero instead of null. Is there a way to display null when null and zero when the value is zero? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup Null values
=if(vlookup(...)="","",vlookup(...))
Babylooch wrote: I am looking up values in a Pivot Table. If the value is null, the formula is displaying zero instead of null. Is there a way to display null when null and zero when the value is zero? -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup Null values
Dave,
Thank you. I thought I tried that, but I guess not. If the "If" statement is true (=""), why doesn't the vlookup display what it looked up ("")? Why do you need to do an IF clause to display what is in the cell anyhow? Just wondering. Val "Dave Peterson" wrote: =if(vlookup(...)="","",vlookup(...)) Babylooch wrote: I am looking up values in a Pivot Table. If the value is null, the formula is displaying zero instead of null. Is there a way to display null when null and zero when the value is zero? -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup Null values
Try this in a test worksheet:
Put this formula in A2: =A1 Notice that it returns a 0. That's just the way excel works. If you want to avoid this problem, you need to do something like: =if(a1="","",a1) Same thing with =vlookup()'s. Babylooch wrote: Dave, Thank you. I thought I tried that, but I guess not. If the "If" statement is true (=""), why doesn't the vlookup display what it looked up ("")? Why do you need to do an IF clause to display what is in the cell anyhow? Just wondering. Val "Dave Peterson" wrote: =if(vlookup(...)="","",vlookup(...)) Babylooch wrote: I am looking up values in a Pivot Table. If the value is null, the formula is displaying zero instead of null. Is there a way to display null when null and zero when the value is zero? -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup Null values
Try changing the format to Custom ;;""
That tells Excel to display zero's as "". "Babylooch" wrote: I am looking up values in a Pivot Table. If the value is null, the formula is displaying zero instead of null. Is there a way to display null when null and zero when the value is zero? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP USING 2 LOOK UP VALUES | Excel Worksheet Functions | |||
cntrl + down arrow and null values in cells | Excel Discussion (Misc queries) | |||
How do I use VLOOKUP to find values across more than 1 sheet or Wo | Excel Worksheet Functions | |||
Multipying columns that contail null values | Excel Discussion (Misc queries) | |||
VLOOKUP FOR MULTIPLE VALUES | Setting up and Configuration of Excel |