+ Reply to Thread
Results 1 to 7 of 7

Display the results of one cell based on another

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Display the results of one cell based on another

    Hi Excel Forum!

    I am working with a formula that works perfectly! Basically, the formula:

    =IF(ISERROR(FIND("TX", AllTracking!AA16)) = FALSE, AllTracking!AB16, "")

    displays the results of AB16 if AA16 match "TX". That works great but now I need to add some layers. I need to add not only "TX", but also "HV", "CSSRS", "GAD" and "SRA". How can I modify my formula to include searching for these items. Using OR maybe??

    Additionally, the cells to look for is actually AA16:AJ16.

    I have also tried =IF(AA17="HV",DA17,IF(AA17="TX",DE17, IF(AA17="SRA",DL17,IF(AA17="GAD",DS17,IF(AA17="PHQ",DO17, IF(AA17="CSSRS",DW17,"")))))) but to no avail....

    Any help will be appreciated!

    Thanks!

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,991

    Re: Display the results of one cell based on another

    =IF(SUM(COUNTIFS(AllTracking!AA16:AJ16,{"TX","HV","CSSRS","GAD","SRA"})),"Yes","No")

    Will return Yes if any of those are found in that range, otherwise No.

    If you include a sample workbook where we can see the desired results, we can modify the output.

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,991

    Re: Display the results of one cell based on another

    If you want to return something different depending on what value is found, you should use a lookup table to do that.

    Basically have one column with the lookup value and one column with the result value, then use a VLOOKUP or INDEX MATCH formula.

  4. #4
    Registered User
    Join Date
    09-11-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Display the results of one cell based on another

    Capture.JPG

    Here is a sample of my data. Basically, each ID is a person. The date is when each code was discussed. I want to display the date the code was discussed with each person in its corresponding column. So 1234 had a code of HV on 10-15-19. In the corresponding column, it shows 10-15-19. I want the date to be entered in the column automatically. So when I type HV and the date, it is returned in the HV Column.

    hope this helps!

    Thanks

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,991

    Re: Display the results of one cell based on another

    You can use this in H3:

    =IFERROR(INDEX($C3:$F3,MATCH(H$2,$B3:$E3,0)),"")
    Drag to the right and down.

    In the future, please post a sample workbook as requested (not a picture).
    See yellow banner towards the top of the page.

  6. #6
    Registered User
    Join Date
    09-11-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Display the results of one cell based on another

    This is perfect!!!!

    Thanks so much!!!!

  7. #7
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,991

    Re: Display the results of one cell based on another

    You're welcome. Happy to help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Display results based on the day of the week
    By olga6542 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-04-2017, 08:53 PM
  2. [SOLVED] Display top three results based on column, based on major
    By alexllap in forum Excel General
    Replies: 2
    Last Post: 07-13-2017, 05:59 PM
  3. Display results based on certain categories of users
    By tnovak in forum Excel General
    Replies: 2
    Last Post: 10-14-2014, 12:51 PM
  4. Excel Sheet to Display results based on a value
    By anthony.maddick in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-26-2014, 08:26 AM
  5. Display numerous results based on three criteria
    By 54321adam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2013, 12:13 PM
  6. Display Top 20 results based on certain criteria
    By ash_farooq in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-11-2012, 02:54 AM
  7. Replies: 1
    Last Post: 03-20-2009, 08:05 PM

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