| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"" ,VLOOKUP(F2,Mast
Hello Excel guru's,
How do I change this formula: =IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"" ,VLOOKUP(F2,Master!A:D,2,0)) So that it will return a blank field instead of a '0' if the cell it's referencing is blank? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| =IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
| =IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
| embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
| How to replace "#N/A" w "0"when vlookup couldn't find the match? | Excel Discussion (Misc queries) | |||
Threaded Mode
