+ Reply to Thread
Results 1 to 8 of 8

Need help returning specific text value based on criteria

  1. #1
    Registered User
    Join Date
    01-12-2019
    Location
    New York
    MS-Off Ver
    1811 (office 365)
    Posts
    21

    Need help returning specific text value based on criteria

    Hi there,

    I need help returning the desired result in Column G. Not sure if to nest the IF and SUBSTITUTE formulas.

    In the attachment I have two identical list (Text 1 and Text 2). If the values in Text 2 is different than Text 1, i would like the values in Text 2 to supersede the values in Text 1.


    Thank you for any help.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,894

    Re: Need help returning specific text value based on criteria

    Uh, am I missing something. You always want Text 2 then. Formula in G2 would be:
    =B2
    and copied down.

  3. #3
    Registered User
    Join Date
    01-12-2019
    Location
    New York
    MS-Off Ver
    1811 (office 365)
    Posts
    21

    Re: Need help returning specific text value based on criteria

    well the problem is that these two columns I'm comparing are in separate tabs or worksheets. So I do need to find a way of comparing both list and returning the value only if it differs.

  4. #4
    Registered User
    Join Date
    01-12-2019
    Location
    New York
    MS-Off Ver
    1811 (office 365)
    Posts
    21

    Re: Need help returning specific text value based on criteria

    I tried to simplify the example (see attachment), I realized it was confusing.
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,894

    Re: Need help returning specific text value based on criteria

    So it seems to me you're saying, if Column B is blank, then show Column A, otherwise, show column B

    If you put this formula in the 2nd row (any column) and then copied it down, you would get the same results you are showing in Column E (Your desired results)

    =IF(B2="",A2,B2)

  6. #6
    Registered User
    Join Date
    01-12-2019
    Location
    New York
    MS-Off Ver
    1811 (office 365)
    Posts
    21

    Re: Need help returning specific text value based on criteria

    what if I only had column A and not column B, how would I be able to return the substituted value in column G? I was hoping there was a way to do it without creating a helper column.

  7. #7
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,894

    Re: Need help returning specific text value based on criteria

    You could create a table of your substitute words, then use this:

    =XLOOKUP(A2,Table1[Original],Table1[Substitute],A2,0)
    (I put this formula in D2 and copied down)

    (the substitute table starts in H5)

    See attached.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    01-12-2019
    Location
    New York
    MS-Off Ver
    1811 (office 365)
    Posts
    21

    Re: Need help returning specific text value based on criteria

    i love you thank you very much

+ 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. Replies: 2
    Last Post: 10-31-2018, 04:16 PM
  2. [SOLVED] Question: Returning a specific text based on the date
    By MBauer12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-04-2016, 08:21 AM
  3. Writing a formula for returning a text value based on multiple criteria
    By DataAnalyst215 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2016, 06:55 PM
  4. Returning text against text based criteria
    By dejathorus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2014, 04:50 PM
  5. [SOLVED] Look up based on specific text criteria.
    By tokyojo1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2014, 03:08 PM
  6. [SOLVED] Requesting help returning text values from criteria based on multiple columns
    By dzarrabi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2013, 08:16 AM
  7. Replies: 6
    Last Post: 02-07-2012, 08:21 PM

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