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...
Can this formula handle the long array of $K$28:$K$400 ?
There are hundreds of partial matches that can trigger the "true" aspect.
The cell was blank after using this initial formula despite there being a partial match.
There are hundreds of partial matches that can trigger the "true" aspect.
The cell was blank after using this initial formula despite there being a partial match.