| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statements
Hi,
I have been successfully using the following statement: =IF(ISERROR(VLOOKUP(A17,'Data Base'!$A$1:$Y$413,14,FALSE)),"",VLOOKUP(A17,'Data Base'!$A$1:$Y$413,14,FALSE)) I want to add another if to this, so that I get: If lookup results in error message, leave blank (first part above) If lookup results in the value 0, leave blank (how do I add this?) Otherwise, put result of lookup (second part above) How do I had the the second IF to this equation so that if the lookup results in the value 0, leave blank? -- Julie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If, then statements | Excel Discussion (Misc queries) | |||
| If, Then Statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| IF Statements | Excel Discussion (Misc queries) | |||
| If statements | Excel Worksheet Functions | |||
Threaded Mode
