Forum Discussion
Formula for .. IF Partial Match = PASTE, IF NO MATCH = BLANK
Hello everyone, I'm looking for a partial match formula. I'm looking to partial match cell $D5 in my excel spreadsheet with $K$28:$K$400. $D5 must be a PARTIAL MATCH to ANY of the cells i...
In E5
=IF( SUM( COUNTIFS(D5, "*" & $K$28:$K$33 & "*" ) ), D5, "" )"2" matches one the cells in K-range
Yes but that was just for this test example. In my workbook, I do not have a "2", I would only add a "2" if it included a space before or after the like " 2" or "2 " or" 2/" or "/2 " etc.
So, " 285" has the space before "2", is that the case? Or it shall be between " " and/or "/" as separators. If "etc." means any other separators could exists, which ones?