| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup blanks = zeros
Hello
=IF(ISERROR(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE))," ",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE)) Whenever there is a blank in the cell is returns 0. If the cell is blank I want the answer to be blank not a zero. Can someone help me thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup blanks = zeros
Try this:
=IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)=0,"",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "Marilyn" wrote in message ... Hello =IF(ISERROR(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE))," ",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE)) Whenever there is a blank in the cell is returns 0. If the cell is blank I want the answer to be blank not a zero. Can someone help me thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup blanks = zeros
Just in case the values you're returning are numbers use this one:
=IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)="","",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "T. Valko" wrote in message ... Try this: =IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)=0,"",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "Marilyn" wrote in message ... Hello =IF(ISERROR(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE))," ",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE)) Whenever there is a blank in the cell is returns 0. If the cell is blank I want the answer to be blank not a zero. Can someone help me thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup blanks = zeros
thanks T Valko this works.. I noticed that your formula s has a 0 instead
of the word false. what is the difference what does 0 mean in this position thanks "T. Valko" wrote: Just in case the values you're returning are numbers use this one: =IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)="","",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "T. Valko" wrote in message ... Try this: =IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)=0,"",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "Marilyn" wrote in message ... Hello =IF(ISERROR(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE))," ",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE)) Whenever there is a blank in the cell is returns 0. If the cell is blank I want the answer to be blank not a zero. Can someone help me thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup blanks = zeros
The 0 means the same thing as FALSE, look for an exact match. I'm just lazy
and don't like to type a lot! 1 would mean the same thing as TRUE, look for an approximate match. Biff "Marilyn" wrote in message ... thanks T Valko this works.. I noticed that your formula s has a 0 instead of the word false. what is the difference what does 0 mean in this position thanks "T. Valko" wrote: Just in case the values you're returning are numbers use this one: =IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)="","",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "T. Valko" wrote in message ... Try this: =IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)=0,"",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "Marilyn" wrote in message ... Hello =IF(ISERROR(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE))," ",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE)) Whenever there is a blank in the cell is returns 0. If the cell is blank I want the answer to be blank not a zero. Can someone help me thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup blanks = zeros
thanks good to know
"T. Valko" wrote: The 0 means the same thing as FALSE, look for an exact match. I'm just lazy and don't like to type a lot! 1 would mean the same thing as TRUE, look for an approximate match. Biff "Marilyn" wrote in message ... thanks T Valko this works.. I noticed that your formula s has a 0 instead of the word false. what is the difference what does 0 mean in this position thanks "T. Valko" wrote: Just in case the values you're returning are numbers use this one: =IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)="","",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "T. Valko" wrote in message ... Try this: =IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)=0,"",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "Marilyn" wrote in message ... Hello =IF(ISERROR(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE))," ",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE)) Whenever there is a blank in the cell is returns 0. If the cell is blank I want the answer to be blank not a zero. Can someone help me thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup blanks = zeros
You're welcome. Thanks for the feedback!
Biff "Marilyn" wrote in message ... thanks good to know "T. Valko" wrote: The 0 means the same thing as FALSE, look for an exact match. I'm just lazy and don't like to type a lot! 1 would mean the same thing as TRUE, look for an approximate match. Biff "Marilyn" wrote in message ... thanks T Valko this works.. I noticed that your formula s has a 0 instead of the word false. what is the difference what does 0 mean in this position thanks "T. Valko" wrote: Just in case the values you're returning are numbers use this one: =IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)="","",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "T. Valko" wrote in message ... Try this: =IF(COUNTIF('Jan 3 06'!C3:C28,C4),IF(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)=0,"",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,0)),"") Biff "Marilyn" wrote in message ... Hello =IF(ISERROR(VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE))," ",VLOOKUP(C4,'Jan 3 06'!C3:F28,4,FALSE)) Whenever there is a blank in the cell is returns 0. If the cell is blank I want the answer to be blank not a zero. Can someone help me thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Why VLOOKUP formula does not show blanks or N/A ? | Excel Discussion (Misc queries) | |||
| What formula is used to replace blanks in spreadsheet with zeros? | Excel Worksheet Functions | |||
| blanks instead of "0" in vlookup | Excel Discussion (Misc queries) | |||
| Blanks chart as zeros | Charts and Charting in Excel | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Linear Mode
