remove zeroes in 1 column vbaTrouble getting VLOOKUP to workdoes 1 row from excel worksheets exist in another...

Was the old ablative pronoun "med" or "mēd"?

Can a virus destroy the BIOS of a modern computer?

What is the opposite of "eschatology"?

Unlock My Phone! February 2018

In the UK, is it possible to get a referendum by a court decision?

Can someone clarify Hamming's notion of important problems in relation to modern academia?

Does Dispel Magic work on Tiny Hut?

how do we prove that a sum of two periods is still a period?

Is it possible to map the firing of neurons in the human brain so as to stimulate artificial memories in someone else?

How to remove border from elements in the last row?

How can a day be of 24 hours?

Solving an equation with constraints

How to compactly explain secondary and tertiary characters without resorting to stereotypes?

What is the most common color to indicate the input-field is disabled?

Does the Idaho Potato Commission associate potato skins with healthy eating?

Mathematica command that allows it to read my intentions

Implication of namely

Processor speed limited at 0.4 Ghz

What is a Samsaran Word™?

How obscure is the use of 令 in 令和?

One verb to replace 'be a member of' a club

Machine learning testing data

Different meanings of こわい

Are British MPs missing the point, with these 'Indicative Votes'?



remove zeroes in 1 column vba


Trouble getting VLOOKUP to workdoes 1 row from excel worksheets exist in another worksheet. If so copy, copy value from cellExcel VBA to fill a column with formula until (last filled cell in another column)How to get a Range of cells as an function argumentFind all matching occurrences in one column following matching criteria for another columnComparing two columns with partial values and getting info on match and column numberIndex/Match for an entire table rather than a single columnCan Someone Please Explain How This VLOOKUP-MATCH-INDEX Formula worksPerform calculation on columns based on column headerDropdown List autofill to last row













-1















Let me replace my question,



=INDEX('" & Filename & folder1 & "[" & ffname1 & "]Customers'!C21,MATCH(C6,'" & Filename & folder1 & "[" & ffname1 & "]Customers'!C2,0))


This is my code for matching some data to my master file.
My problem is, if the column for matching is blank or have an empty value the output of the matching is equal to 0
I want the output to be exact as what is in the master file.



for example, if some of the cells are blanks, it should be blank. But I don't know how.



I don't know how to explain it but I guess you guys know what I'm saying I hope??. Is just like returning 0 in vlookup?










share|improve this question





























    -1















    Let me replace my question,



    =INDEX('" & Filename & folder1 & "[" & ffname1 & "]Customers'!C21,MATCH(C6,'" & Filename & folder1 & "[" & ffname1 & "]Customers'!C2,0))


    This is my code for matching some data to my master file.
    My problem is, if the column for matching is blank or have an empty value the output of the matching is equal to 0
    I want the output to be exact as what is in the master file.



    for example, if some of the cells are blanks, it should be blank. But I don't know how.



    I don't know how to explain it but I guess you guys know what I'm saying I hope??. Is just like returning 0 in vlookup?










    share|improve this question



























      -1












      -1








      -1








      Let me replace my question,



      =INDEX('" & Filename & folder1 & "[" & ffname1 & "]Customers'!C21,MATCH(C6,'" & Filename & folder1 & "[" & ffname1 & "]Customers'!C2,0))


      This is my code for matching some data to my master file.
      My problem is, if the column for matching is blank or have an empty value the output of the matching is equal to 0
      I want the output to be exact as what is in the master file.



      for example, if some of the cells are blanks, it should be blank. But I don't know how.



      I don't know how to explain it but I guess you guys know what I'm saying I hope??. Is just like returning 0 in vlookup?










      share|improve this question
















      Let me replace my question,



      =INDEX('" & Filename & folder1 & "[" & ffname1 & "]Customers'!C21,MATCH(C6,'" & Filename & folder1 & "[" & ffname1 & "]Customers'!C2,0))


      This is my code for matching some data to my master file.
      My problem is, if the column for matching is blank or have an empty value the output of the matching is equal to 0
      I want the output to be exact as what is in the master file.



      for example, if some of the cells are blanks, it should be blank. But I don't know how.



      I don't know how to explain it but I guess you guys know what I'm saying I hope??. Is just like returning 0 in vlookup?







      microsoft-excel vba






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 37 mins ago







      gee

















      asked 1 hour ago









      geegee

      344




      344






















          1 Answer
          1






          active

          oldest

          votes


















          0














          no need to answer this question guys!! I already solved my problem :D I used IFERROR(IF(...)) formular for this






          share|improve this answer
























            Your Answer








            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "3"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1420665%2fremove-zeroes-in-1-column-vba%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            no need to answer this question guys!! I already solved my problem :D I used IFERROR(IF(...)) formular for this






            share|improve this answer




























              0














              no need to answer this question guys!! I already solved my problem :D I used IFERROR(IF(...)) formular for this






              share|improve this answer


























                0












                0








                0







                no need to answer this question guys!! I already solved my problem :D I used IFERROR(IF(...)) formular for this






                share|improve this answer













                no need to answer this question guys!! I already solved my problem :D I used IFERROR(IF(...)) formular for this







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 32 mins ago









                geegee

                344




                344






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Super User!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1420665%2fremove-zeroes-in-1-column-vba%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

                    Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

                    Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...