+ Reply to Thread
Results 1 to 8 of 8

Generate cell value based on adjacent cell text

  1. #1
    Registered User
    Join Date
    09-12-2018
    Location
    belfast
    MS-Off Ver
    365 MSO (16.0.10730.20088) 32-BIT
    Posts
    3

    Generate cell value based on adjacent cell text

    Apologises if I have come to the wrong thread section.
    I am looking to populate cells with numeric values based on the text content from another cell

    For example if Call A1 says "Flooring" I need cell B1 to automatically show 25

    There will be 10 possibilities for for the text and each one requires a link to different value

    The cells in Row A will be selected from a limited drop down table

    is this possible?

    Thank you in advance

    Carl
    Last edited by ginjaone; 09-12-2018 at 09:48 AM. Reason: EXAMPLE SHOWN

  2. #2
    Registered User
    Join Date
    09-12-2018
    Location
    D.C
    MS-Off Ver
    2016
    Posts
    4

    Re: Generate cell value based on adjacent cell text

    I think you can use the countifs/sumifs formula to do that of you want the sum of the result, for instance the sum or count of a an item in the data but if you want the exact result, then vlookup will suffice.
    Let me know if you need further elaboration or an example, better yet if you send a sample data, I can do it for you.

  3. #3
    Registered User
    Join Date
    09-12-2018
    Location
    belfast
    MS-Off Ver
    365 MSO (16.0.10730.20088) 32-BIT
    Posts
    3

    Re: Generate cell value based on adjacent cell text

    Hi Samtwe really struggling to be honest. Can I send you a sheet

  4. #4
    Registered User
    Join Date
    09-12-2018
    Location
    D.C
    MS-Off Ver
    2016
    Posts
    4

    Re: Generate cell value based on adjacent cell text

    Yes, you can.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Generate cell value based on adjacent cell text

    You can use something like
    =VLOOKUP(A1,{"flooring",25;"Wall",30;"ceiling",95},2,0)

  6. #6
    Registered User
    Join Date
    09-12-2018
    Location
    belfast
    MS-Off Ver
    365 MSO (16.0.10730.20088) 32-BIT
    Posts
    3
    Quote Originally Posted by Fluff13 View Post
    You can use something like
    =VLOOKUP(A1,{"flooring",25;"Wall",30;"ceiling",95},2,0)
    Thats Brilliant thank you. Thanks too samtwe.

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Generate cell value based on adjacent cell text

    glad to help & thanks for the feedback

  8. #8
    Registered User
    Join Date
    09-12-2018
    Location
    D.C
    MS-Off Ver
    2016
    Posts
    4

    Re: Generate cell value based on adjacent cell text

    Quote Originally Posted by ginjaone View Post
    Hi Samtwe really struggling to be honest. Can I send you a sheet
    I am terribly sorry! I got interrupted with a project and totally forgot to come back to this. I am so sorry!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to have a cell auto-generate text based on text from another cell?
    By wgilles in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2015, 02:46 PM
  2. Replies: 11
    Last Post: 04-30-2015, 05:35 PM
  3. How to: Auto-pop text based on text of adjacent cell
    By BobWiley85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2013, 04:44 PM
  4. Generate a list based on the text in adjacent cell
    By Alkarzar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2013, 03:48 PM
  5. [SOLVED] SUMIF based on text in adjacent cell
    By kevinjay1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-07-2013, 06:33 PM
  6. Macro that will clear contents of cell based on format of text in adjacent cell
    By judasdac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2012, 01:56 AM
  7. Copy a Cell value based on text from adjacent cell
    By db41987 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2010, 10:59 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1