Results 1 to 8 of 8

Need help returning specific text value based on criteria

Threaded View

  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

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