Forum Discussion

Brass Contributor

Aug 13, 2023

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...

excel

Excel on mobile

Formulas and Functions

office 365

SergeiBaklan

Diamond Contributor

Aug 15, 2023

Cmoreno89

Yes, that makes difference. Looks like

Do I understood correctly you have two durations, before and after. Filter works on any of it if we have just number. If number between space and slash, we filter before. If number between slash and comma, we filter after. Or we don't need comma? - after the slash till end of the text. any other combinations?

In initial sample there are only numbers, not very clear how slash and space are used in combination with them.

Cmoreno89

Brass Contributor

Aug 15, 2023

$D5 will constantly change. But the column K range will not. I need $D5 to be copied over to $E5 only if it's a partial match to any of the cells in the K column range. The formula has to check every cell in K range. So lets say K28 has "123"... if D5 has any *123*, then $D5 will appear in $E5. If not, then $E5 will be left blank.

Is this making sense?

SergeiBaklan
Diamond Contributor
Aug 15, 2023
Cmoreno89

We started from that. If K28 has "2" initial formula returned D5 into E5. If no "*2*" in D5, when blank.

Answer was that's not correct, we shall take into account slashes and spaces. So the question is where are slashes and spaces, directly in K28 of we shall around "2" with them in formula.