+ Reply to Thread
Results 1 to 3 of 3

Help! Formula: Look up multiple text string and return multiple values

  1. 09-23-2014, 02:39 PM #1
    Kchiolero
    Kchiolero is offline
    Registered User
    Join Date
    09-18-2014
    Location
    Denver, CO
    MS-Off Ver
    2010
    Posts
    2

    Exclamation Help! Formula: Look up multiple text string and return multiple values

    Hello,

    I am not sure if what I am about to ask is even possible. Any help, is much appreciated. Thanks in advance!

    Here it goes:

    Column A
    Formula>

    Column B
    Apple
    Apple I love my apple
    Banana
    Banana I love my banana
    Banana Trust the banana
    Corn
    Corn
    Corn I love my corn
    Corn Trust

    I want to look up Column B and if it states "Banana" or "Apple" or "Corn" to Return in Column A it's appropriate match, see below example. Is this possible?

    A B


    Apple Apple
    Apple Apple I love my apple
    Banana Banana
    Banana Banana I love my banana
    Banana Banana Trust the banana
    Corn Corn
    Corn Corn
    Corn Corn I love my corn
    Corn Corn Trust
    Reply With QuoteRegister To Reply
  2. 09-23-2014, 02:48 PM #2
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,296

    Re: Help! Formula: Look up multiple text string and return multiple values 

    Please Login or Register  to view this content.
    Try this one
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  3. 09-23-2014, 03:06 PM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Help! Formula: Look up multiple text string and return multiple values

    If you only want to return the matching fruit in col. A if col. B contains either Apple, Banana or Corn, try this.....
    Assuming your string is in B1, then
    In A1
    Please Login or Register  to view this content.
    Otherwise Willem's formula will do the trick.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Redistributing text values in a text string in one cell into multiple cells as numbers
    By Meta Self in forum Excel General
    Replies: 4
    Last Post: 07-21-2014, 10:33 AM
  2. Sub to remove text from string in multiple cells then return in one
    By DadaaP in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2013, 04:04 AM
  3. Search text string and return value based on multiple criteria
    By cmill02s in forum Excel General
    Replies: 1
    Last Post: 04-08-2013, 07:07 PM
  4. Lookup then Search for text string and return multiple entries
    By tnewell2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-24-2012, 12:11 PM
  5. Formula to look up multiple values and extract text from string - Facebook Advertising
    By bcommando17 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-31-2012, 11:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1