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

**:) Sixthsense :)** · 07-28-2015, 07:10 AM

Originally Posted by crazyb78

I unfortunately don't want to sum them but it will be useful later on in my project so thank you.

Or

In E2 Cell

=IFERROR(LOOKUP(2,1/SEARCH(LEFT(D2,FIND(" ",D2&" ")-1),$B$2:$B$8),$C$2:$C$8),"")

Drag it down

But don't expect accurate result. When there is no reliable search text then the result will also won't be a reliable one

**crazyb78** · 07-28-2015, 07:15 AM

Thanks - That didn't give me what I wanted either unfortunately. Column D is only for reference and the numbers don't need to correspond to D but should align with B and C. I will eventually put the reference columns into their on sheet once I figure out the function / formula.

Thanks for helping so far.

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

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Looking for PART of a cell, in another column and return corresponding value

Find a word contained in a cell that matches a word in a list

[SOLVED] Look up a column and return a value 1 cell below the word yes

[SOLVED] Formula to find multiple part matches in a range of cells and return value if each exists

Look for a cell's text value in a column and if it matches return the cell value of match

[SOLVED] Counting Cells Containing Part of a Text, that matches critera in another column

Change the value of the cell if part of it matches

Bookmarks

Bookmarks

Posting Permissions