+ Reply to Thread
Results 1 to 4 of 4

Fill Cell Based on Row Content

  1. #1
    Registered User
    Join Date
    08-05-2007
    Posts
    9

    Fill Cell Based on Row Content

    I have a worksheet that I was hoping someone could give me a hand on.

    I have a row L7 through AP7 that will either contain a 1 or a 2. For example cell L7 through Y7 each one could have a 1 or a 2 in it. not both.

    Based on that input I would like cell J7 to display a text either 1st for a 1 displayed or 2nd for a 2 displayed.

    These cells will either have a 1 or a 2 (not both).

    Thanks a ton in advance.

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by SailorGuy
    I have a worksheet that I was hoping someone could give me a hand on.

    I have a row L7 through AP7 that will either contain a 1 or a 2. For example cell L7 through Y7 each one could have a 1 or a 2 in it. not both.

    Based on that input I would like cell J7 to display a text either 1st for a 1 displayed or 2nd for a 2 displayed.

    These cells will either have a 1 or a 2 (not both).

    Thanks a ton in advance.
    As you told that those cells can only contain 1 or 2, you can use following formula to return 1st or 2nd.

    =IF(L7=1,"1st","2nd")

    Is it the same you required?

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    If you want an error (#VALUE!) to appear if there is anything other than a 1 or 2, enter and copy across,

    =CHOOSE(L7, "1st", "2nd")

  4. #4
    Registered User
    Join Date
    08-05-2007
    Posts
    9
    Ok I apologize for not clarifying myself a little better so I've attached a sample of my file that I am working with in hopes that someone will be able to help me out.

    Basically on a given ROW. If cell H7 through U7 have either a 1 or a 2 anywhere in that cell range then I would like it to output 1st Holiday period in cell F7. If anything is in cell W7 through AL7 then I would like it to output 2nd Holiday Period in cell F7.

    Thanks a ton for your assistance.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1