+ Reply to Thread
Results 1 to 6 of 6

Formula that inputs specific text in a cell, based on what number is in the adjacent cell

  1. 11-17-2018, 12:57 PM #1
    agarford
    agarford is offline
    Registered User
    Join Date
    03-18-2013
    Location
    Peterborough, UK
    MS-Off Ver
    Excel 2013
    Posts
    13

    Formula that inputs specific text in a cell, based on what number is in the adjacent cell

    Hello!

    I am looking for some help regarding a formula for the below.

    If numbers 1, 2, 3 or 4 appear in cell A7 (for example), I would like the text 'SINGLE' to appear in cell A8.
    If numbers 5, 6, 7, 8, 9, 10, 11, 12, 13 or 14 appear in cell A7, I would like the text 'DOUBLE' to appear in cell A8.
    If numbers 15 or above appear in cell A7, I would like the text 'TRIPLE' to appear in cell A8.

    Does anyone know how to formulate this? I have experimented with IFSEARCH, and ISNUMBER forumula but I'm struggling to make it work.

    Any help would be greatly appreciated! :-)
    Reply With QuoteRegister To Reply
  2. 11-17-2018, 01:05 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Formula that inputs specific text in a cell, based on what number is in the adjacent c

    Try this in A8:

    =LOOKUP(A7,{1,5,15},{"SINGLE","DOUBLE","TRIPLE"})
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 11-17-2018, 01:47 PM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Formula that inputs specific text in a cell, based on what number is in the adjacent c

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  4. 11-18-2018, 03:03 AM #4
    agarford
    agarford is offline
    Registered User
    Join Date
    03-18-2013
    Location
    Peterborough, UK
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: Formula that inputs specific text in a cell, based on what number is in the adjacent c

    Thank you so much!!! That works perfectly.

    To take it a step further slightly, say I have two separate sheets (called SHEET1 and SHEET2). How do I get the formula to reflect the total number shown in cell A7 on both sheets.

    For example...

    If cell A7 on SHEET1 + SHEET2 = 1,2,3 or 4, I need cell A8 (on both sheets) to say 'SINGLE'
    If cell A7 on SHEET1 + SHEET2 = 5,6,7,8,9,10,11,12,13,14 I need cell A8 to say 'DOUBLE'
    If cell A7 on SHEET1 + SHEET2 = 15+ I need cell A8 to say 'TRIPLE'

    Any further help would be brilliant.
    Reply With QuoteRegister To Reply
  5. 11-19-2018, 01:26 AM #5
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Formula that inputs specific text in a cell, based on what number is in the adjacent c

    Just copy what Ali gave you from SHEET1 and paste into cell A8 of SHEET2 (?)
    Dave
    Reply With QuoteRegister To Reply
  6. 11-19-2018, 01:52 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Formula that inputs specific text in a cell, based on what number is in the adjacent c

    Maybe this, then?

    =LOOKUP(Sheet1!A7+Sheet2!A7,{1,5,15},{"SINGLE","DOUBLE","TRIPLE"})

    This is really basic stuff in terms of cell references - are you completely new to Excel?
    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. [SOLVED] Get Cell value from adjacent cell if it has specific number or Text - 1 in given case
    By analystbank in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-13-2018, 04:03 AM
  2. Formula determining tab from which to extract information based upon text in adjacent cell
    By th355 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2015, 12:36 PM
  3. [SOLVED] Text in a cell, then formula to put a particular number in adjacent cell
    By jojo101 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-17-2014, 09:09 AM
  4. VBACode to check adjacent cell if a cell has specific text & highlite w conditional format
    By usumban in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2013, 01:49 PM
  5. [SOLVED] Return number based on two cell inputs
    By NZK in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-03-2013, 09:09 PM
  6. Return number based on two cell inputs.
    By NZK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-19-2012, 08:55 PM
  7. Formula for date change based on text in adjacent cell
    By checklist in forum Excel General
    Replies: 5
    Last Post: 04-21-2011, 10:30 AM

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