+ Reply to Thread
Results 1 to 3 of 3

Outcome generated in cell from pre populated list, dependent on value/answer in other cell

Hybrid View

  1. #1
    Registered User
    Join Date
    01-04-2023
    Location
    England
    MS-Off Ver
    365
    Posts
    2

    Outcome generated in cell from pre populated list, dependent on value/answer in other cell

    Hi all,

    Apologies I'm sure this is really simple but I'm on a deadline and this has been thrown at me!

    I am looking to create an outcome in cell C1 dependent on the answer to a question in cell B1 and generated from a pre-populated list from column A on another tab in the same worksheet.

    As an example.

    Question in cell A1. If the answer to the question is "Yes" in B1 then it will populate "We would advise that you seek the advice of a GP" in C1 as linked to a generated list in A1 on the next tab.
    Question in cell A1. If the answer to the question is "No" in B1 then it will populate "No further action required" in C1 as I'll ask it to link to the value A2 on the next tab.
    Question in cell A1. If the answer to the question is "Don't know" then it will populate "Please see HR" in C1 as I'll ask it to link to the value of A3 on the next tab.

    My limited skills tell me it's along the lines of (I don't know the exact terminology) that IF the value in B1 is "Yes" then display the information from A1 (on the other tab).

    I really hope I've explained this properly.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Outcome generated in cell from pre populated list, dependent on value/answer in other

    Try:
    =IF(B1="Yes","See the Doc",IF(B1="No","NFA",IF(B1="Don't know","Refer to HR","")))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    01-04-2023
    Location
    England
    MS-Off Ver
    365
    Posts
    2

    Re: Outcome generated in cell from pre populated list, dependent on value/answer in other

    Thank you so much for your help! I think my colleague has managed to go one step further and populate the responses from the generated list...I'm just waiting for her to get back to me.

+ 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. Cell outcome dependent on multiple other variables (text and number)
    By willhub in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-08-2022, 10:05 AM
  2. [SOLVED] Multi dependent dropdowns with auto-generated cell
    By AlPragOrg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2021, 11:24 AM
  3. Replies: 0
    Last Post: 06-20-2019, 07:42 PM
  4. [SOLVED] "If cell populated, and matches, then outcome" query???
    By millerchris in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-25-2014, 07:55 AM
  5. [SOLVED] Return a specified answer dependent on a cell value
    By major88 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-10-2014, 12:08 PM
  6. Return a specified answer dependent on a cell value
    By major88 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 04-10-2014, 10:45 AM
  7. [SOLVED] outcome of a cell dependent an value of a set of 3 cells
    By matwalker in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2013, 11:08 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1