Results 1 to 21 of 21

Return value when part of a cell matches a word in a reference column

Threaded View

crazyb78 Return value when part of a... 07-28-2015, 06:13 AM
Pete_UK Re: Return value when part of... 07-28-2015, 06:23 AM
crazyb78 Re: Return value when part of... 07-28-2015, 07:05 AM
cbatrody Re: Return value when part of... 07-28-2015, 06:23 AM
crazyb78 Re: Return value when part of... 07-28-2015, 06:48 AM
Glenn Kennedy Re: Return value when part of... 07-28-2015, 06:37 AM
:) Sixthsense :) Re: Return value when part of... 07-28-2015, 06:41 AM
crazyb78 Re: Return value when part of... 07-28-2015, 07:02 AM
:) Sixthsense :) Re: Return value when part of... 07-28-2015, 07:10 AM
crazyb78 Re: Return value when part of... 07-28-2015, 07:15 AM
cbatrody Re: Return value when part of... 07-28-2015, 06:55 AM
crazyb78 Re: Return value when part of... 07-28-2015, 07:00 AM
cbatrody Re: Return value when part of... 07-28-2015, 07:00 AM
samba_ravi Re: Return value when part of... 07-28-2015, 07:23 AM
samba_ravi Re: Return value when part of... 07-28-2015, 07:29 AM
Pete_UK Re: Return value when part of... 07-28-2015, 08:34 AM
crazyb78 Re: Return value when part of... 07-28-2015, 04:40 PM
crazyb78 Re: Return value when part of... 07-28-2015, 05:00 PM
Pete_UK Re: Return value when part of... 07-28-2015, 09:26 PM
  1. #14
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: Return value when part of a cell matches a word in a reference column

    Try the below array formula (Ctrl+Shift+Enter) and copy towards down
    =IFERROR(INDEX($C$2:$C$8,MATCH(1,COUNTIF($D2,"*"&REPLACE(LEFT($B$2:$B$8,FIND("-",$B$2:$B$8)-1),1,8,"")&"*"),0)),"")
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 14
    Last Post: 11-04-2014, 02:41 PM
  2. Replies: 15
    Last Post: 05-28-2014, 05:57 AM
  3. [SOLVED] Look up a column and return a value 1 cell below the word yes
    By Martin Chamberlin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-01-2013, 03:46 PM
  4. Replies: 9
    Last Post: 07-03-2013, 07:39 AM
  5. Replies: 1
    Last Post: 08-02-2012, 11:39 PM
  6. Replies: 2
    Last Post: 07-14-2011, 09:04 AM
  7. Change the value of the cell if part of it matches
    By egalitarian87 in forum Excel General
    Replies: 2
    Last Post: 05-10-2010, 01:49 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