| Home |
| Search |
| Today's Posts |
|
#6
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. |
| 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 | |||
Threaded Mode
