| 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. |
| 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
