Hi all,
I have a formula that is not quite capturing what I need it to....
Formula is:
but since I didn't creat the formula, I do not have the knowledge enough to tweak it. It currently returns part of a cells contents, summed (a number value); however, I need it to return the entire contents of the cell....![]()
=SUM(IF(ISNUMBER(FIND(" "&$R2&" "," "&B4:H4&" ")),LEFT(B4:H4,FIND(" ",B4:H4)-1)+0))
Example:
Currently returns: 10
Want it to return: 10 OT L1P
Spreadsheet attached - thanks
Bookmarks