| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"" ,VLOOKUP(F2,Mast
What type of data does the formula return, is it text, numeric, could be
either? -- Biff Microsoft Excel MVP "Jim" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"" ,VLOOKUP(F2,Mast
=IF(or(ISNA(VLOOKUP(F2,Content_Insert!A:A,1,0)),
VLOOKUP(F2,Master!A:D,2,0)=""),"",VLOOKUP(F2,Maste r!A:D,2,0)) -- HTH... Jim Thomlinson "Jim" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"" ,VLOOKUP(F2,Mast
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"" ,IF(VLOOKUP(F2,Master!A:D,2,0)="","",VLOOKUP(F2,Ma ster!A:D,2,0)))
But you may want to test for an error in VLOOKUP(F2,Master!A:D,2,0) too. You've tested for an error in a different VLOOKUP. -- David Biddulph "Jim" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
