+ Reply to Thread
Results 1 to 8 of 8

search cells for partial match and return cell value

  1. #1
    Registered User
    Join Date
    01-27-2020
    Location
    england
    MS-Off Ver
    office 365, excel version 1912
    Posts
    53

    search cells for partial match and return cell value

    Hi im looking for formula to search 2 cells,find partial match and return cell value.
    Where the word "new" is found.

    A1 = new blue shorts
    A2 = blue jeans

    So B1 would return the cell content of A1, answer new shorts
    Thanks

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: search cells for partial match and return cell value

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Try in B1
    Punnam

  3. #3
    Registered User
    Join Date
    01-27-2020
    Location
    england
    MS-Off Ver
    office 365, excel version 1912
    Posts
    53

    Re: search cells for partial match and return cell value

    Quote Originally Posted by Punnam View Post
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Try in B1
    Punnam
    Thanks but that only searches a1, i need it to search 2 cells for word

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: search cells for partial match and return cell value

    ste33uk ,

    A sample sheet with results manually will be easy, kindly check the yellow banner on top.

    Punnam

  5. #5
    Registered User
    Join Date
    01-27-2020
    Location
    england
    MS-Off Ver
    office 365, excel version 1912
    Posts
    53

    Re: search cells for partial match and return cell value

    Have attached book
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: search cells for partial match and return cell value

    ste33uk ,
    I am sorry, hope someone else could help from here.

    Punnam

  7. #7
    Registered User
    Join Date
    01-27-2020
    Location
    england
    MS-Off Ver
    office 365, excel version 1912
    Posts
    53

    Re: search cells for partial match and return cell value

    Quote Originally Posted by Punnam View Post
    ste33uk ,
    I am sorry, hope someone else could help from here.

    Punnam
    No Problem, thanks for help

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: search cells for partial match and return cell value

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Partial match then return value from a different cell
    By emueller in forum Excel General
    Replies: 4
    Last Post: 03-03-2020, 08:34 AM
  2. Return values that do not match partial search
    By tangoecho in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2020, 04:52 PM
  3. Search and Match partial text string to full text and return a value
    By homa5424 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2017, 10:52 AM
  4. Replies: 9
    Last Post: 09-05-2017, 11:35 AM
  5. [SOLVED] Lookup partial values and if match return partial value from another cell
    By Renejorgensen in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-01-2017, 07:53 AM
  6. Replies: 0
    Last Post: 09-21-2013, 09:03 PM
  7. Return cell contents on a partial match
    By rhani111 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2008, 12:13 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1