Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if vlookup
I'm using a vlookup to populate my summary sheet with data from the MASTER
DATABASE sheet =VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE) The above formula works fine - except for when the cell where I am pulling the data from is blank. Excel then returns a value of 0 and I want the cell to remain blank. I know this is some variation of an IF statement but can't get it to work. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if vlookup
=IF(VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)="","",VLOOKUP($B2, 'MASTER
DATABASE'!$A:$AY,8,FALSE)) See if this does the trick, if it is blank it should stay blank otherwise it will calculate your formula. "Christine" wrote: I'm using a vlookup to populate my summary sheet with data from the MASTER DATABASE sheet =VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE) The above formula works fine - except for when the cell where I am pulling the data from is blank. Excel then returns a value of 0 and I want the cell to remain blank. I know this is some variation of an IF statement but can't get it to work. Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if vlookup
Try this:
=IF(VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)=0,"",VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)) Alternatively, you could keep the formula as it is and apply conditional formatting to the cell, such that if the cell contents is zero then choose the foreground colour to be white, so that a zero will show up as a blank. Hope this helps. Pete Christine wrote: I'm using a vlookup to populate my summary sheet with data from the MASTER DATABASE sheet =VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE) The above formula works fine - except for when the cell where I am pulling the data from is blank. Excel then returns a value of 0 and I want the cell to remain blank. I know this is some variation of an IF statement but can't get it to work. Thank you. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if vlookup
This formual returns "#N/A" for everything, even cells that have data in them.
"tim m" wrote: =IF(VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)="","",VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)) See if this does the trick, if it is blank it should stay blank otherwise it will calculate your formula. "Christine" wrote: I'm using a vlookup to populate my summary sheet with data from the MASTER DATABASE sheet =VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE) The above formula works fine - except for when the cell where I am pulling the data from is blank. Excel then returns a value of 0 and I want the cell to remain blank. I know this is some variation of an IF statement but can't get it to work. Thank you. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if vlookup
THANK YOU!
"Pete_UK" wrote: Try this: =IF(VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)=0,"",VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)) Alternatively, you could keep the formula as it is and apply conditional formatting to the cell, such that if the cell contents is zero then choose the foreground colour to be white, so that a zero will show up as a blank. Hope this helps. Pete Christine wrote: I'm using a vlookup to populate my summary sheet with data from the MASTER DATABASE sheet =VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE) The above formula works fine - except for when the cell where I am pulling the data from is blank. Excel then returns a value of 0 and I want the cell to remain blank. I know this is some variation of an IF statement but can't get it to work. Thank you. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if vlookup
My apologies, tough to check some of these formulas without actual data. I
think if you follow what Pete has posted it will work as he is checking to see if the result = 0 where i had erroneously checked for a "". "Christine" wrote: This formual returns "#N/A" for everything, even cells that have data in them. "tim m" wrote: =IF(VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)="","",VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)) See if this does the trick, if it is blank it should stay blank otherwise it will calculate your formula. "Christine" wrote: I'm using a vlookup to populate my summary sheet with data from the MASTER DATABASE sheet =VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE) The above formula works fine - except for when the cell where I am pulling the data from is blank. Excel then returns a value of 0 and I want the cell to remain blank. I know this is some variation of an IF statement but can't get it to work. Thank you. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if vlookup
You're welcome.
Pete Christine wrote: THANK YOU! "Pete_UK" wrote: Try this: =IF(VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)=0,"",VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)) Alternatively, you could keep the formula as it is and apply conditional formatting to the cell, such that if the cell contents is zero then choose the foreground colour to be white, so that a zero will show up as a blank. Hope this helps. Pete Christine wrote: I'm using a vlookup to populate my summary sheet with data from the MASTER DATABASE sheet =VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE) The above formula works fine - except for when the cell where I am pulling the data from is blank. Excel then returns a value of 0 and I want the cell to remain blank. I know this is some variation of an IF statement but can't get it to work. Thank you. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if vlookup
Try This:
=iserror(VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE), "", VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)) Hope this will help Hitesh "Pete_UK" wrote: Try this: =IF(VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)=0,"",VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE)) Alternatively, you could keep the formula as it is and apply conditional formatting to the cell, such that if the cell contents is zero then choose the foreground colour to be white, so that a zero will show up as a blank. Hope this helps. Pete Christine wrote: I'm using a vlookup to populate my summary sheet with data from the MASTER DATABASE sheet =VLOOKUP($B2, 'MASTER DATABASE'!$A:$AY,8,FALSE) The above formula works fine - except for when the cell where I am pulling the data from is blank. Excel then returns a value of 0 and I want the cell to remain blank. I know this is some variation of an IF statement but can't get it to work. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |