+ Reply to Thread
Results 1 to 9 of 9

Input text in one cell and it populates another cell with different text

  1. 10-10-2016, 09:54 PM #1
    roseyj
    roseyj is offline
    Registered User
    Join Date
    10-10-2016
    Location
    Houston, Texas, US
    MS-Off Ver
    Office 2010
    Posts
    6

    Red face Input text in one cell and it populates another cell with different text

    I apologize ahead of time for being confusing. I can clarify if needed.


    I pretty much need a contingency spreadsheet to help me make decisions of people.

    I want cell C12 to populate with a certain name based on the names being populated in cells C2:C11.

    The formula in cell C12 I have tried but only gives me that one answer to one question: =IF(C2="BOB","JOHN","BOB")
    So if C2 is populated with "BOB", then C12 will show "JOHN", but if it does not say "BOB then C12 will say "BOB."

    I have been unable to get this to work but I would like the IF formula to let me pick the range of cells to do the text search and if the name I am looking for is there it will give me a text output I choose.

    This is the formula that will not work:
    =IF(C2:C11="BOB","JOHN","BOB")




    This is only an example:
    Capture.JPG


    Thanks so much!
    Last edited by roseyj; 10-10-2016 at 11:02 PM. Reason: had a typo, changed A2:A11 to C2:C11
    Reply With QuoteRegister To Reply
  2. 10-10-2016, 10:54 PM #2
    tamthat
    tamthat is offline
    Forum Contributor
    Join Date
    11-21-2015
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 2016
    Posts
    146

    Re: Input text in one cell and it populates another cell with different text

    I don't see data in range A2:A11
    Reply With QuoteRegister To Reply
  3. 10-10-2016, 10:56 PM #3
    tamthat
    tamthat is offline
    Forum Contributor
    Join Date
    11-21-2015
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 2016
    Posts
    146

    Re: Input text in one cell and it populates another cell with different text

    Quote Originally Posted by roseyj View Post
    This is the formula that will not work:
    =IF(C2:C11="BOB","JOHN","BOB")
    C2:C11 in your formulas: C2:C11 = B =>>> Array formulas. You have to use Ctrl+Shift+Enter when finish your formulas!
    Reply With QuoteRegister To Reply
  4. 10-10-2016, 11:03 PM #4
    roseyj
    roseyj is offline
    Registered User
    Join Date
    10-10-2016
    Location
    Houston, Texas, US
    MS-Off Ver
    Office 2010
    Posts
    6

    Re: Input text in one cell and it populates another cell with different text

    Sorry for the typo, it should say C2:C11
    Reply With QuoteRegister To Reply
  5. 10-10-2016, 11:09 PM #5
    tamthat
    tamthat is offline
    Forum Contributor
    Join Date
    11-21-2015
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 2016
    Posts
    146

    Re: Input text in one cell and it populates another cell with different text

    Quote Originally Posted by roseyj View Post
    Sorry for the typo, it should say C2:C11
    Yes, you can use:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 10-10-2016, 11:19 PM #6
    roseyj
    roseyj is offline
    Registered User
    Join Date
    10-10-2016
    Location
    Houston, Texas, US
    MS-Off Ver
    Office 2010
    Posts
    6

    Re: Input text in one cell and it populates another cell with different text

    Quote Originally Posted by tamthat View Post
    C2:C11 in your formulas: C2:C11 = B =>>> Array formulas. You have to use Ctrl+Shift+Enter when finish your formulas!
    The Ctrl+Shift+Enter worked great, thank you!


    Is there a way to male this work?

    =IF(C2:C4="BOB","JOHN","BOB"), IF(C2:C4="JOHN", "LARRY","LARRY"), IF(C2:C4="LARRY", "JEN","LARRY")



    Also, when I put this =IF(COUNTIF($C$2:$C$5,"BOB"),"JOHN","BOB") in to C5, it gives me a 0. Do you know how I could fix this?


    Thanks so much
    Last edited by roseyj; 10-10-2016 at 11:39 PM. Reason: added a question
    Reply With QuoteRegister To Reply
  7. 10-11-2016, 01:03 AM #7
    tamthat
    tamthat is offline
    Forum Contributor
    Join Date
    11-21-2015
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 2016
    Posts
    146

    Re: Input text in one cell and it populates another cell with different text

    Quote Originally Posted by roseyj View Post
    The Ctrl+Shift+Enter worked great, thank you!


    Is there a way to male this work?

    =IF(C2:C4="BOB","JOHN","BOB"), IF(C2:C4="JOHN", "LARRY","LARRY"), IF(C2:C4="LARRY", "JEN","LARRY")



    Also, when I put this =IF(COUNTIF($C$2:$C$5,"BOB"),"JOHN","BOB") in to C5, it gives me a 0. Do you know how I could fix this?


    Thanks so much
    Because in your formulas, $C$2:$C$5 include $C$5, you can't use address C5 when you put formulas in C5. You must type: $C$2:$C$4.
    Reply With QuoteRegister To Reply
  8. 10-11-2016, 01:16 AM #8
    roseyj
    roseyj is offline
    Registered User
    Join Date
    10-10-2016
    Location
    Houston, Texas, US
    MS-Off Ver
    Office 2010
    Posts
    6

    Re: Input text in one cell and it populates another cell with different text

    Ahh I see,

    Ok last question.. how can I put multiple of this formula in this one cell?

    I tried just putting a comma between them like below but this did not work (I had seen that on another Excel help website):

    =IF(COUNTIF($C$2:$C$5,"BOB"),"JOHN","BOB"), IF(COUNTIF($C$2:$C$5,"LARRY"),"BOB","LARRY") .... and so on..


    Thanks again for your great help
    Reply With QuoteRegister To Reply
  9. 10-11-2016, 03:13 AM #9
    tamthat
    tamthat is offline
    Forum Contributor
    Join Date
    11-21-2015
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 2016
    Posts
    146

    Re: Input text in one cell and it populates another cell with different text

    A problem needs a particular circumstance, I don't have particular problem, I can't help you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find text in all rows of column and input text into cell next to it
    By Empumpu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2015, 08:20 AM
  2. How to input text into a cell without the text function
    By razkowski in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-15-2015, 02:54 PM
  3. [SOLVED] If a cell has text then input text into another, unless there is text in there already
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2013, 10:57 AM
  4. Text Box that opens when cell is click and populates based on a lookup
    By Whirlpool in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2013, 07:55 AM
  5. [SOLVED] Leave text in a cell when same cell has no text input.
    By rastak1 in forum Excel General
    Replies: 9
    Last Post: 07-12-2013, 12:51 AM
  6. Change text colour when input cell is less or greater than 1000 to the reference cell
    By Teenwolf in forum Excel General
    Replies: 2
    Last Post: 10-08-2012, 08:10 AM
  7. If the sum of a cell is a certain text then a dollar amount populates another cell
    By avidcat in forum Excel General
    Replies: 2
    Last Post: 09-10-2009, 05:40 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1