Results 1 to 6 of 6

Return Text From a Cell if It Contains One of Many Texts

Threaded View

  1. 11-28-2022, 01:17 PM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    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: Return Text From a Cell if It Contains One of Many Texts

    Or, since you have O365, a SPILL array that does it all in a single cell:

    =BYROW(A2:A7,LAMBDA(x,LOOKUP(1E+100,FIND(G1:G6,x),G1:G6)))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Return all texts where the adjacent cell is >0
    By Enounce in forum Excel General
    Replies: 9
    Last Post: 03-06-2021, 03:21 PM
  2. [SOLVED] Search for two texts and return two times another cell if present and return 1 times
    By josygeorge000 in forum Excel General
    Replies: 9
    Last Post: 05-03-2020, 03:01 AM
  3. [SOLVED] Find Multiple Texts and Replace Texts / Blanks within a List of Texts
    By ibuhary in forum Excel General
    Replies: 11
    Last Post: 04-09-2019, 09:50 AM
  4. Search for several texts and return a spesific text
    By mariur89 in forum Excel General
    Replies: 2
    Last Post: 11-24-2014, 07:37 PM
  5. Search for multiple texts in cell, return specific text
    By mariur89 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-24-2014, 06:43 PM
  6. URGENT: How to match a text cell with a list of texts and return a desired string of text
    By Cyson in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-18-2014, 09:36 AM
  7. Search the text in 3rd cell by using texts in 2 cells
    By Shinaj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2014, 08:08 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1