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 in my filter array, $K$28:$K$400. (This column K array contains " " and "/" a well. Not sure if that will be an issue.)
If there is a match, then I would like $D5 copied and pasted over into $E5 (which is where this formula will be typed).
If there is no match, I would like $E5 to return a blank cell.
Also, I am doing this on an excel mobile app, so I cannot use VBA.
And I already tried using chatgpt to no avail. 😞
Can anyone help?
Thank you in advance
33 Replies
- Adem
- Ayodi1995
- 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. - Didn't work. 😞
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
