Using an IF Formula with a combo box

  • Re: Using an IF Formula with a combo box


    The sheet name is the name you see on the tab at the bottom of the file window. You will rename all the sheets that have spaces in the names by double clicking on the tab and typing in the revised name.


    Jim

  • Re: Using an IF Formula with a combo box


    Nat


    A16 to A42 on the Home Page can be deleted if you don't need them for anything else (structure, ...)


    I fixed it: use in cell B7:


    =INDIRECT(ADDRESS(ROW(C6),COLUMN(C6),,,INDEX($B$16:$B$42,$B$3)))


    Then drag down and to the right.


    Wigi

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: Using an IF Formula with a combo box


    Jim,

    THANKS!!!!!!!!!!!!!!!!!!!! YOU'RE THE BEST that was bugging me big time thanks for ya help!

    Are you any good at linking sheets from one file to another so that it updates the cells automatically????

    ill make a new post!

  • Re: Using an IF Formula with a combo box



    Hello Jim


    This thread has become quite unstructured, but anyway, spaces are possible. Look at my solution if you want to.


    Wigi

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: Using an IF Formula with a combo box


    Thanks Natalie,


    Wigi is your real hero. I would take his formula so you don't have to worry about the spaces after this.


    Jim

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!